[ACCEPTED]-Getting "Invalid bracketing of name" error when i try to run query on excel sheet-worksheet
Accepted answer
I had this same problem, replaced the . with 1 a # and it works. Thanks!
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.
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
Source:
stackoverflow.com
More Related questions
Cookie Warning
We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.