Populating a Table

R

RFJ

I've just created an empty database and want to import the data from a table
in another database to a similar table in the new one.

Can sks tell me how to do it. (Ive experimented with the 'Get External
Data/Import' option but it just seems to import the whole table).


TIA

Rob
 
C

Cheryl Fischer

Link the table in the other database, using File|Get External Data|Link.
You can then create an append query to put records from this table into the
table in your new empty database.
 
Top