Exporting Records

  • Thread starter Thread starter Martin
  • Start date Start date
M

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
 
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.
 
Back
Top