Exporting Records

[Martin]

Hi

I want to export a set of records found by a query to
either a Access file or an Excel spreadsheet. Basically I
want these to act as an archive, when the export is
complete the records will be deleted. The problem is
whenever I export the records in the query it overwrites
the entire file and deletes ones I have previously
exported. Is there any way to stop this and just add the
records to the file?

Thanks for the help

Martin

 

[John Nurick]

Hi Martin,

Assuming you already have an mdb file containing a table with one set of
archived records, the simplest thing is probably to set this up as a
linked table in your "main" database. Then convert the query you're now
exporting into in append query, to append the soon-to-be-deleted records
to the linked table.

But this sort of archive-and-delete approach is often unnecessary. An
Access database can comfortably hold hundreds of megabytes of data,
millions of records.