Results 1 to 4 of 4
  1. #1
    Icon is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    7

    Unexpected error from external database driver (1)

    I get the error message Unexpected error from external database driver (1) when I try to import an Excel document using the import wizard. Does anyone know what this error is?



    Thanks.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I am not familiar with the error. Is it Access that displays the error message? Was the Excel file created by Microsoft Office. Is the Excel file macro enabled (you can check the file extension, if it ends with m)?

  3. #3
    Icon is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    7
    Quote Originally Posted by ItsMe View Post
    I am not familiar with the error. Is it Access that displays the error message? Was the Excel file created by Microsoft Office. Is the Excel file macro enabled (you can check the file extension, if it ends with m)?
    Here are the answers to your questions.
    1. Yes, the error displays in Access.
    2. No, the file is an export from SAP.
    3. No, the file is not Macro enabled. The file has the .xlsx extension.

    That being said I was able to make it work. I tried downloading the file from the source again but I still get the same error message. When that didn't work I tried copying the data into a new excel spreadsheet. I was then able to import the data.

    However, that wasn't the solution I was looking for. I'm trying to automate this process and plan on building macros to go get the file and import automatically. If I have to do this for every file download that defeats the purpose of the macro.

    What I'm looking for is the reason why I get that error message and how to avoid it in the future.

    Thanks.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    What I'm looking for is the reason why I get that error message and how to avoid it in the future.
    I believe the issue is the file was not generated using Microsoft Office. It seems likely that this is the issue since your import procedure was successful after using MS Office to copy the data into a new file.

    I do not know what process you are using to import. You might try different approaches using VBA. Ultimately, I believe you will need to automate Excel from VBA and import the data that way.

    Here is a partial of Automating Excel. You will need to make a reference. I believe the one you need is MS Office Object Library

    Code:
    Dim xlApp As Excel.Application
    Dim myBook As Workbook
    Dim mySheet As Worksheet
    Set xlApp = New Excel.Application
    Set myBook = xlApp.Workbooks.Open(strPath & "Template\Product_By_PO.xlsx")
    Set mySheet = myBook.Sheets.Item(1) 'Grab the first worksheet

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Using INSERT INTO from external database
    By Williams485 in forum Queries
    Replies: 6
    Last Post: 02-19-2015, 03:43 AM
  2. Replies: 1
    Last Post: 05-29-2013, 03:08 PM
  3. Replies: 1
    Last Post: 01-29-2013, 10:24 AM
  4. Delete in external database
    By theosgood in forum Programming
    Replies: 3
    Last Post: 10-06-2012, 01:27 PM
  5. Error Linking External Table
    By mcgowan.b in forum Import/Export Data
    Replies: 9
    Last Post: 11-24-2009, 07:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums