Karthi keyan

Karthi keyan

  • NA
  • 74
  • 5.1k

Problem reading Excel Sheet name which contains special char

Jun 10 2015 6:21 AM
when i was reading the excel by using oledb, it is retrieving the data sucessfully. But when the sheet name contains '#' , it does not reading the data.
It gives the following error.
" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

Answers (5)