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

[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

 

[Mark]

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

 

[waldorfedu]

THanks

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