OLEDB Error reading Header Name ("State")
 

Hi,

I am using Jet.OleDb.4.0 and using OLEDB reader to read csv file using
DataReader. If the column name in CSV file is STATE then DataReader.GetName
(index) returns FileName#.csv.State.

It works fine with excel and all other names are fine with CSV. If I change
the column header to Stat then everything works fine. How could i resolve
this issue without changing the header name in excel file

Thanks,

PP