Linked Tables

[Renetta]

I am linking Access to several same data type excel spread sheets and then
completing a merge of those spread sheets via Union Quiry. I then use this
info for reporting purposes for filing/merge documents for mailing. My
problem is that the excel data is going to be over written monthly with
updated data, which is from another data base. The reason for this is I felt
it better to over write the excel info vs recreating the Union Quiry along
with recreating the other quires associated with the Union Quiry. But, I
would like to keep record of the data each month in one location for future
referencing. Any suggestions on how I can automate that process as much as
possible. I'm thinking some sort of additional quiery and or table of some
sort. Please provide suggestions/direction if possible.

Thanks.

 

[Pat Hartman\(MVP\)]

If the data exists in another place, why do you feel the need to archive it?
If you want to save the spreadsheet, copy it after you use it and give it a
name that includes the date of the data.