ODBC Excel Driver: Unexpected error from external database driver

excel delphi odbc ado delphi-10.1-berlin
Bram picture Bram · Oct 12, 2017 · Viewed 10.7k times · Source

Since the Windows update from October 10, the ODBC Excel drivers have stopped working. We get the following error when trying to read a file:

"Unexpected error from external database driver (1)"

We open Excel files in Delphi using an ADO connection with the following connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

I can get it to work by switching to Microsoft.ACE.OLEDB.12.0, but for that to work, all our customers would have to install the Microsoft Access Database Engine Redistributable on all the computers they use our software on.

Does anybody have another solution or workaround? Thanks in advance.

Answer

donhauro picture donhauro · Oct 12, 2017

On a customers machine I have deinstalled KB4041681 (Windows 7) which came with last Microsoft Patch. On my machine I have deinstalled KB4041676 (Windows 10). After that Microsoft.Jet.OLEDB.4.0 is now working.

I hope that Microsoft will fix this bug soon.

Related questions

Exporting to excel from Delphi without having excel

I'm looking to export data to excel from Delphi without having to own a copy of excel, is this possible? N.B. CSV will not do.

Read More
Ole 800A03EC error when using TExcelWorkBook SaveAs method in Delphi 7

I am trying to open excel 2003 workbook and save it as something else, for example excel 95. I use the following code: XLSApp:=TExcelApplication.Create(Self); XLSApp.Workbooks.Open(SomeFileName,NULL,false,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,…

Read More
Import data from Excel

I want to import data from Excel into a Paradox database on Delphi 7. How can I do that using Delphi?

Read More