Populating a Table

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

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.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


"RFJ" wrote in message
...
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