sql - odbc

stampe

My Navision is 2.50 and running on a ms-sql server the problem ocur when i am trying to acsess the database with the sql sever odbc, I can se all the tables and chose fields from the tables but when I try to fininsh the ODBC wizard, this error ocur " Incorrect Syntax near 'Ltd'." this is when i am trying to acsess a table named "CRONUS International Ltd.$Customer" i think its either the "$" or the "." that causes the problem but what settings do i have to change to avoid this problem ?
If I try to acsess the database with ADO (OLE-DB) i get the same error with this syntax
"SELECT * From CRONUS International Ltd.$Customer"

while this syntax works

"SELECT * From [CRONUS International Ltd.$Customer]"

Pls. help

Thanks

Peter Nielsen

John_Tegelaar

You are answering your own question. Because of the company name, you need to surround the table name with square brackets.

Which ODBC wizard you are talking about? Are you trying to set up a System DSN? Which driver? What parameters have you used/set?

John

stampe

Hello John

I am talking about the wizard that is in ms excel where you chose an odbc connection,i dont have an english version of excel but thi´nk its the Data menu and then "Get external data" or something like that.
I have made an system dsn where i use the sql server driver.

It is correct that in ms query i can write the sql-statement and then get the data, but i was hoping that the wizard could do the work

Peter