Archiving Records

[agrogers15]

Hello MrExcel experts! I am just starting to work with MS Access and need help with my chosen method of archiving records.

The reason for this is I do not have access to my companies database servers, so to prevent the database from crashing from too many entries, I want to offload old records to an excel file.
What I have started for this is I created an archive table to which records will be stored until exported to excel then deleted. The part I need help with is creating a macro that will autorun once a month and append everything in the archive table to an existing excel file. Data cannot be overwritten. The other issue is the excel file will need to be on a corporate share site.

Is this possible?

 

[mole999]

Not really the answer you want, but why not add an additional column to your recordset as a flag, then you place a marker in that and have your normal data queries ignore those records. Unless your data set is excessively large may it not be managed just in Access

 

[xenou]

if feasible it's simplest to just delete all the records in the Excel file, then refresh it by adding back all the new data from the archive table. This makes it unnecessary to do all the work of figuring out what's "new" and what's "already there".