I have a 2010 Excel file
with a sheet that spans 34864 rows
and 1387 columns
. I'm trying to import it into Access 2010
with the import wizard, but when I select that sheet, Access goes unresponsive, and after several seconds gives me a
"Unexpected error from external database driver (1)"
Is this due to the size of the sheet or is there something in the cells that stops it from working. Other sheets from the same file import with no problem.
Solved for Windows 7:
Uninstall Security Update KB4041681 and KB4041678 both(Related to Excel and Jet/ACE provider)
A solution that has worked for me when tackling this issue is to have the Excel File where the Import / Export is being executed open when the Import & Export is happening.
The issue appears to be caused by the Patch preventing data transaction from occurring between CLOSED .xls files and other external database applications. Having the excel file open addresses this issue.
Some sample code examples below to highlight what works and what doesn't with VBA:
FAILS
WORKS
I was getting this error when importing from a XLSB file, save the file as XLSX file and then import, should work
Save your Excel sheet to a 'Comma delimited' .CSV file, and then upload it as Text File. For me, this works fine.
The problem is that in .xls(x) all kind of lay-out issues are present. Converting it into .CSV removes all lay-out related mark up and converts in into 'raw' data.
all the best!
In my case (I has the same error) the problem was that I had the Access DB stored on a network drive which ran out of space (not enough free space for the import to finish). I freed up space and compacted the DB; the error didn't appear again.
You may experience this error after installing security patch KB4041681. See this MSDN entry. In my case, replacing
Microsoft.Jet.OLEDB.4.0
provider withMicrosoft.ACE.OLEDB.12.0
helped.