Excel & ODBC

[mazsolt]

Hello, I've some problems accessing an Excel file through ODBC.
I connected to the file (using dsn), but I don't know which one to use as table-name (select * from 'table-name').
I tried with Sheet1, Table1, but it didn't work.
Can anyone help me?
Thanks in advance!

[bad76]

Hi,
You have to set a NAME for the data.
In EXCEL select the range of your data, then in insert menu select name->define and tell a name. This name is now your table.

I don't know the exact name of menu because i have my language localizzation. If need i can send a screenshot.
see you.

[mazsolt]

thanks bad, you have already given me some useful advices. Your solution works, and I solved the problem.

[bad76]

😃 i'm already go crazy with this problem, some time ago !!! and m$ help don't help me more...

At next time ...