I was using DAO to access a database in my program. I read in a text file, extract the values and then insert them into the appropriate table in my Database (Access 2000). Using the DAO reading a file with ~ 1500 lines(1 record per line) and then inserting into the database happend quite quickly (~ 1 sec or less). However, I was interested in trying out ADO. When I use the ADO to run the same piece of code the execution takes around 10 minutes. Am I missing an important setting or something. I am very new at VB so maybe someone out there knows what I am doing wrong. It just doesn't seem right that there should be such a difference.

Thanks.