inserting records - fast!

[alexmac]

Hi I am relatively new to the world of databases and ADO and wonder if anyone has any tips on speeding up writing to databases.
My program reads a text file then strips out data before writing to an Access 2000 database with ADO.

Thanks,

Alex

Reading from text files and writing to MS Access Database is slow in the first place (Access is not a true relational database, it's a file database), therefore, use something better if you could (MS SQL Server, Oracle, etc.).
If you have to use Access, don't use ADO build-in methods such as AddRecord, Delete, etc.
Code SQL statements instead, it's faster.

[alexmac]

Thanks for your help. I think it may soon be time to learn how to use SQL server...

Alex

[Chris]

Try to use the INSERT INTO... VALUES sql statement.

Cheers!