Pls post the actual SQL code whe you have SQL issues. Also name the
Database platform and version and OS as well.

I suspect you use SQL server 2000. and have a name with dots . pls
surround each (part) of an sql identiefier with double quotes or square
brackets when doing an Excel query.

select * from "my.database"."dbo"."my.table"
or select * from [my.databse].[dbo].[my.table]

Access automatically maps illegal characters to legal ones, so
[my.databse].[dbo].[my.table] becomes my_database_dbo_my_table

DM Unseen