View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Change source of linked database query

so, this is a query you've linked from Access to Excel, correct?

you should be able to edit the query by going to Data - Import External Data
- Edit Query...

"Rob" wrote:

Does anyone know how to change the source of a linked Access database query?
I need to change the source from the current database to a newly created
database.