"mtate" wrote in message
...
Question...
We have quite a few queries developed in Excel/MS Query that query an
AS400.
We need to share these with users at other locations that use an AS400
with
a different name. Is there any way around changing the SQL FROM statement
for the AS400 machine name to another AS400 machine name without editing
the
query in MS Query and doing it in View, SQL? Looking for the quick, easy
way
to do this, because there are too many to change this way.

I think one way to do this would be to use ADO instead. With this approach
you can get the connection from an .udl file. Thus, you don't have to edit
the code. It's not an easy and quick way, though. The question is
interesting and I will follow it.

/Fredrik