Has any one had any problems, using the Microsoft Text Driver to parse a CSV file.

This driver seems to work ok, until it hits a certain row (same row everytime), and then ADO will not get a value from a field in the row in the CSV. I have checked the watch window, and ADO is certain that the value is not there, and replaces it with NULL. If however I move this row to the beginning of the CSV file, and run the program again, it all works fine.

We have loaded the CSV file into notepad, and there appears to be no funny characters around it.

Has anyone had this problem before, or know of a fix for it.


oConnFile.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"Dbq=c:\steve\;" & _
"Extensions=asc,csv,tab,txt;"

oRsFile.CursorLocation = adUseClient
oRsFile.Open "Select * From db1.csv", oConnFile, , , adCmdText

Any help would be great.

Steve