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

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
 
W

waldorfedu

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
How to Populate Data from a table to another 0
How to export table from outlook into ms access table? 0
How to unlink TOC from a doc 0
import data from excel 2003 to a table in an existing database 2
Add records of one table to another table 7
Excel Protection 2
delete records from one table if not in another 9

Top