copy records from a table in one file to a table in another file

  • Thread starter Thread starter waldorfedu
  • Start date Start date
W

waldorfedu

How do I copy records from a table in one file to a table in another file.
Every time I try to do it message "cannot do it because Table is in use by
another user". Please advise as if you are talking to an idiot - thanks
 
THanks

Mark said:
Open the database you want to copy to to the database window and display the
list of tables. Click on File - Get External Data - Import and select the
database you want to copy from. Select the table you want to copy from.
Click import. You will now see the copy from table in the list of the first
database. Create an append query to append all the records in the copy from
table to the table where you want those records.

Steve
Click to expand...
 
Back
Top