Board index » delphi » Insert bulk data using ADO?

2003-08-11 11:35:08 AM
delphi80
Do anyone know how to insert a bulk record from text file into access by using ADO? For example, I have 50 record and stored in text and I try not to using update statement to insert record one by one cause is time consume. One more thing that I have not MS Access install on my PC and I using the ODBC driver to connect that MS Access .mdb file.
 

Do not use ODBC driver with ADO - use Jet provider. Execute
SELECT * INTO MyTable FROM FileName IN ""[Text; DATABASE=C:\Temp]
Parameters of text file are in schema.ini file in the same directory as text
file - look MSDN for "shema.ini" for more info.
----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.
"Kok Chuan" <XXXX@XXXXX.COM>ÓÏÏÂÝÉ?ÓÏÏÂÝÉÌÁ ?ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅ?
using update statement to insert record one by one cause is time consume.
One more thing that I have not MS Access install on my PC and I using the
ODBC driver to connect that MS Access .mdb file.