Hi Neil,
Query: I am currently importing data in an excel
spreadsheet from Access using MS query via the "Get
External Data" option.
My data source keeps on changing so I am updating the
query using the following route:
Edit Query
View the query using MS Query, look at the SQL statement
and amend the file source, save query, go back to excel.
The problem I have is when I open the spreadsheet it
still thinks it is linked to previous Access databases
which I have used in previous version of the query.
How do I prevent this.
Also is there a way of editing these queries through VBA.
It is baffling me where the code for the import is bing
held.
You could download and test Dick Kusleika and my Query manager:
www.jkp-ads.com/QueryManager.zip
Regards,
Jan Karel Pieterse
Excel MVP
JKP Application Development Services
www.jkp-ads.com