And it also means going through the text file twice, first to get the total number of records and again to import each one.

It sounds like the text file is delimited in some way (you mention records). In that case it will be far quicker and easier to use ADO to read the file.
I've found the following article very useful: http://msdn.microsoft.com/library/de...ng03092004.asp