Handling Special Characters when reading Excel file

  • Thread starter Thread starter Rohit
  • Start date Start date
R

Rohit

Hello,

When trying to read an excel file, one of the Column names contains special
Characters such as "Vehicle ' " [ ( & % $ # @ ! ~ ` ^ * Name".

When i read this excel file using OLEDB in VB.NET, I get an error message.

How can i load the excel file with this column header?

Solutions Please?

Regards,
Rohit
 
Back
Top