[ACCEPTED]-Getting "Invalid bracketing of name" error when i try to run query on excel sheet-worksheet

Accepted answer
Score: 12

I had this same problem, replaced the . with 1 a # and it works. Thanks!

Score: 1

It looks like your sheet name [1. page$] is 6 invalid. This is OK for an Excel sheet 5 name, but not OK in the query. You should 4 not have the "." in your sheet name.

You 3 can't get around the "." problem. It's 2 just not valid when you are running the 1 query.

Score: 1

SpreadsheetGear for .NET will let you work with Excel files without 4 the limitations imposed by OleDb.

You can 3 see C# and VB samples here and try it yourself 2 by downloading the free trial here.

Disclaimer: I 1 own SpreadsheetGear LLC

More Related questions