getting an Unexpected error from external database driver (1) when importing data from excel to access
excel, import, ms-access
Solution
You may experience this error after installing security patch KB4041681. See this MSDN entry. In my case, replacing `Microsoft.Jet.OLEDB.4.0` provider with `Microsoft.ACE.OLEDB.12.0` helped.
Problem
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.