MS Query automatically fully qualifying SQL Select Statement

G

grubstar

Hi,

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

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

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

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

Thank
 
Top