importing from access

Hi, i currently have a spreadsheet that auto imports upon opening and every 5 minutes thereafter from a access query. i set it up simply via going through Data/import external data etc.

At the begginning of each new month the query in the access database will be changed to show activity in the new month. I am wishing to create a new spreadsheet each month to import the new months data from the same query in access. the problem is that if i go to open a previous months spreadsheet - it will also auto update with the new months data. I do not wish for this to happen as i wish to keep a archive. i cannot seem to find anything allowing me to disconnect the external link and to keep the data that i have in the spreadsheet.

Any solutions?

Thanks in advance.

Unfortunately, that would mean i need 12 seperate queries in access. I only wish to have 1.

Idea: could i possibly define a date parameter in the spreadsheet that gets passed onto the access query date field before before importing takes place?
In otherwards, each spreadsheet indicates the month it represents, which gets passed onto the query and inturn the query sends back that particular months data?

I know that last idea is rather more complicated as initially i was looking for something which would allow me to simply disconnect the external link.

hey.. instead of having 12 queries.. just have the one query but in each months tab in your excel file.. when you are setting up the importing in the query wizard.. just filter the date tab to include only that month ?? shudnt that work !

thanks for ur idea. the last idea would certainly work, but as the year goes on..the data in the access database is going to get huge. it would mean importing a huge amount of data only to then filter down to a particular month.

the best thing in theory would be if someway i could get the excel spreadsheet to send over a parameter ( eg: >31/12/07 and <01/02/08) for a particular month to the access query before importing. i have no idea how to do that or if its possible at all. hmm....