>If I understand you, you can use FileSystemObject(FSO).
>Open a reference to Microsof Scripting Runtime, and then....
> Dim a As Scripting.TextStream
> Dim b As Scripting.FileSystemObject
> Set a = b.OpenTextFile("YourFile.csv")
>This, put your csv file, line by line in a TextStream Object, then you can cut line in pieces (well, pieces separated by commas) using Mid, Left, and other VBA string functions.
>Try it!!!
>I hope help you with this.

Thanks for the feedback. I was hoping to use ADO because it references the fields by their names. This method may also be faster as well (with the large text files I am using).