Import records from one table to other

  • Thread starter Thread starter giannis
  • Start date Start date
G

giannis

I want to import all the records from a table
to another table that is not empty (has already
other records).
I cant use Import (access create new table)
but neither Export (access replaces the existing table).
What must i use (macros, query, VB code) for this
purpose ?
 
Giannis,

This sounds like a job for an Append Query.

- Steve Schapel, Microsoft Access MVP
 
An append query. Press F1 for the help file and look up the
instructions for your version of Access.
 
Back
Top