In order to make some reports i need to parse some excel files. When i try to select records from sheet i get next error: Invalid bracketing of name '1. page$'.
Heres my code:
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [1. page$]", connectionString);
I know it will work if i rename sheet to "page" for example, but as i'm not naming these sheets i need to know how to fix this query to work as it is. What sould I do?