Renaming Access Query used by Excel
 

We want to rename some Access queries that are used by an Excel file in an
External database query. But when we rename the queries in Access, the
Excel Query fails, because is doesn't recognize the renamed queries, and is
still looking for the old query names. Is there an easy way to fix the
Excel query so it is looking for the new query name?

Thanks.

Renaming Access Query used by Excel
 

I haven't tested this, but I'm pretty sure it will work.
Don't rename the Access Query....Make a copy of it in Access and rename the
copy.

Then, in Excel, edit the query
View the SQL code and replace the old query reference with the new one.
Then, return the data

Does that help?

***********
Regards,
Ron


"UEUC2" wrote:

We want to rename some Access queries that are used by an Excel file in an
External database query. But when we rename the queries in Access, the
Excel Query fails, because is doesn't recognize the renamed queries, and is
still looking for the old query names. Is there an easy way to fix the
Excel query so it is looking for the new query name?

Thanks.