I need to read the data in an Access 97 file that has about 400K records.
I would like to use either TurboDelphi Pro or dBASE SE.
I only have Access 2003. What is the easiest way of proceeding
A:
I'm not specifically familiar with TurboDelphi Pro or dBASE SE, but with Delphi / C++ Builder you can open the tables using an ODBC connection.
Create an ODBC DSN in Administrative Tools / Data Sources. Then, you should be able to use data objects in your project to open the tables and access the data.
Kluge
2010-08-04 20:41:16
Do you mean in the BDE Administrator?
ChuckO
2010-08-04 21:31:48
You create the ODBC DSN in Windows, under Control Panel / Administrative Tools / Data Sources (ODBC). Once the DSN is created, then you can open the database using the BDE Administrator and can also connect data components within the IDE.
Kluge
2010-08-04 23:29:47
Tony Toews
2010-08-05 00:16:57
+2
A:
If you decide to go with TurboDelphi, you can use the ADOConnection component on the dbGo tab.
When you Configure the connection string, use the Jet driver and point to your .mdb file. Then use the ADO controls to get at the data.
Bruce McGee
2010-08-04 21:43:29