Application:Excel 2002

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.

Help would be much appreciated