Hi,

MS Query is fully qualifying my SQL Select statement which I am manually
creating using the Get External data function in Excel to get data from SQL
Server

e.g. select * from person changes to select * from dbo.databasename.person
person

Is it possible to stop this happening or is there a different way I can use
the Get External Data function to get data from SQL Server?

I want to distribute the xls file with the queries but the database name may
not be the same on other client machines. Table structure / login is always
the same.

Thanks