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.
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.
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.
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.What I'm looking for is the reason why I get that error message and how to avoid it in the future.
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