Convert text file -> SQL 7 FAST??
Posted on 2001-08-27
I actually want to achieve this in VB, but this forum seems to have the most sql savvy types in it...
There is clearly a faster way to import a text file into a database than using the filesystemobject to iterate through the file, one line at a time, and do an INSERT each time.
I know this because to do this on a text file with 250,000 lines takes about 10-15 minutes, while the Import Data utility takes about 30 seconds!
NB. structure of the text file is one column, one row per line (separated by a LF).
I'm thinking maybe you could use the ODBC text file driver, but I can't find how to implement this.