Microsoft Access Text ODBC Driver on Windows 7

Question

I created a Delphi application which utilizes an ODBC data source to access text files in csv format. The driver is the "Microsoft Access Text Driver". But when I deploy my application on a Windows 7 computer it does not work because this driver is not available (there are only two available in odbcad32: sql native client and sql server)

How can I install this driver? I have tried to install MDAC, but it doesn't do anything. No errors or anythinig, but it just shows a quick scroll bar and that is it. And I have heard that MDAC has been replaced by WDAC on Windows 7.

EDIT: I should add this is Windows 7 Home, not Professional.

Solution 1

You might have to install the Microsoft Jet driver. I believe that Microsoft broke it out of MDAC awhile back, and it is no longer be installed by default.

EDIT After further research it appears that they have removed the text file drivers from the jet engine entirely. You can still use the Microsoft ODBC DB Provider for ODBC Drivers to access dBase and Excel files, but no longer text files.

Solution 2

You have to run the ODBC Administrator from this location:

C:\Windows\SysWOW64\odbcad32.exe

then you will see all the x32 drivers

Solution 3

Project JEDI has an open source TJvCSVDataSet

Solution 4

Why not lighten it up and use a VCL TStringList with TStringList.LoadFromFile() and forget about ODBC, MDAC, WDAC and whatever else weighs down the task at hand?

Solution 5

I found I could access the Microsoft text Driver if my application is compiled targeting x86 cpus.

View more solutions