MS Query automatically fully qualifying SQL Select Statement
 

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

MS Query automatically fully qualifying SQL Select Statement
 

Hi,
if you distribute the file, the file paths might be
different meaning you would have to modify the query for
each user. to do .. on the external data tool bar, click
edit query. when the wizard come up got to page 3. click
veiw query edit query in microsoft query. the the query
comes up in design mode, click viewSQL. you can edit the
query including file path here.
but i might suggest that instead of distributing the file,
put the file on a public access drive.(if possible) This
way all would have access to the file and you would on
have 1 file to update.

-----Original Message-----
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



.