Excel 2007 - SQL srv connection failed with spaces in tablename

Hi there ,

I would like to get some data from an SQL server and found this code from MS.
I just adjusted it for my needs , but it fails when opening the table Historic - Full.
The tablename has a space before and after the - (minus sign).
This is the tablename : "Historic - Full"

Can someone help me how to fix this pls.
Renaming the table on SQLserver is not an option.

thanks in advance
Mario

Please Login or Register  to view this content.

Hmmm, you should never have spaces in a table name.

However, try this:

Please Login or Register  to view this content.

Hi Kyle123 ,

I know about the spaces in names , but this DB has been made by an external company.
Your adjustment works like a charm.

Thanks a lot
Mario

I hope they weren't paid for their services!

Glad it's working