Schema.ini

[SteveG]

I am trying to parse a csv file using the microsoft text driver and a schema.ini file.

I can read the csv into the program, but it does not seem to be taking into account my schema.ini file. In the schema.ini I am setting the ColNameHeader=False yet when I read the records in the first record becomes the column names and the second record actually appears as the first record in the recordset.

objConCSV.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"DefaultDir c:\data\;" & _
"Extensions=csv;"

rsCSVFile.Open "Select * From datafile.csv", objConCSV, , , adCmdText

Any help would be great, this is really starting to annoy me now.

Steve.

[SteveG]

Problem sorted, ok all done now, the problem was a rogue space, had creaped into the file name heading in the schema.ini file.

Now all works, sound as a pound.

Steve.