Microsoft Access Text ODBC Driver on Windows 7

Question

I created a Delphi application that uses an ODBC data source to access csv text files. A driver is a Microsoft Access text driver. But when I deploy my application on a computer running Windows 7, it does not work because this driver is not available (there are only two available in odbcad32: sql native client and sql server)

How to install this driver? I tried to install MDAC, but it does nothing. No errors or any errors, but it just shows the quick scroll bar and that’s all. And I heard that MDAC has been replaced by WDAC on Windows 7.

EDIT: I have to add that this is Windows 7 Home and not Professional.

Answer 1

You may need to install the Microsoft Jet driver. I believe Microsoft left MDAC some time ago and it is no longer installed by default.

EDIT . After further research, it turned out that they completely removed the text file drivers from the jet engine. You can still use the Microsoft ODBC DB provider for ODBC drivers to access dBase and Excel files, but no longer text files.

Answer 2

You must start the ODBC administrator from this location:

C: \ Windows \ SysWOW64 \ odbcad32.exe

then you will see all x32 drivers

Answer 3

JEDI project has open source TJvCSVDataSet

Answer 4

Why not lighten it and use the VCL TStringList with TStringList.LoadFromFile () and forget about ODBC, MDAC, WDAC and what else weighs down under the task?

Answer 5

I found that I can access the Microsoft text driver if my application is compiled with x86 cpus targeting.

Answer 6

I believe that you will need to install this package to get a text driver (among others).

Answer 7

Here's a CSV demo that doesn't need to install any components or write parsing code. If you can call the .Create class method, you can use this code without setting anything.

It uses two single files that implement the JvCsvDataSet component, which is still a class that can be created just like you can create a TStringList, you just create a TJvCsvDatSet.