var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Invalid bracketing of name ' Order Summary$E3:F3'
Rather annoyingly the Excel Spreadsheet im trying to import into SQL has a space before the Sheetname for Example " Sheet1" not "Sheet1".
"SELECT * From [ Order Summary$E3:F3]"
Returns: Invalid bracketing of name ' Order Summary$E3:F3'
And if i remove the space:
"SELECT * From [Order Summary$E3:F3]"
The sheet quite rightly cannot be found.
Sadly the Excel spreadsheet is not mine to change and therefore it is not possible for me to remove the spaces without a great deal of aggro. Is there anyway to get my select statement to work?
gutted i have had no responses i even tried "SELECT * From [" + SPACE + "Order Summary$E3:F3]" but to no avail.