Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    32

    Question 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?

  2. #2
    Join Date
    Jul 2009
    Posts
    32
    gutted i have had no responses i even tried "SELECT * From [" + SPACE + "Order Summary$E3:F3]" but to no avail.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •