"." in csv header causing mapping issue

[collinszac10]

If a column header in a csv file has a decimal it is causing a mapping error even if you manually map the header name.

[jbeem]

I'm having the same problem with an xls file using the ExcelColumn attribute: [ExcelColumn("Pmt. Type")]

[jbeem]

I believe I found a workaround. I stepped into the code and the problem appears to be that the OleDbReader replaces "." with "#". I changed my attribute to use a pound sign (#) in place of the period, i.e. [ExcelColumn("Pmt# Type")], and it's now working.