Hello,

In microsoft access and enterprise manager you have the option of importing delimited text files. In access you use the "file->GetExternal Data" option and in enterprise manager you just right click on a table and press "all tasks->import data" and then select "text file", etc. To import huge text files (a few hundred megabytes) it is very fast. Even when the tables are indexed. However, I haven't been able to duplicate anywhere near this speed in code. I've tried everything (ado.net, ado, command objects, etc) and it's all about 10x slower. What I'm thinking is there is something built in that just makes the import MUCH faster than having a program call 'insert' queries on each individual row. So, the question is:

How can I duplicate that speed? Why are enterprise manager, and microsoft access able to do this so quickly? And what can I do to do the same thing? It is too much to call an insert query for every single row (there are about 2 million rows in the file i'm using now). Is there ANY other way?!!

Thanks in advance