Populating a Table

  • Thread starter Thread starter RFJ
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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

Populate table with data 4
How to export table from outlook into ms access table? 0
Need multiple manager tables that can be sent to individuals 5
Counting unique values in a table 6
How to Populate Data from a table to another 0
Access Import & Link section grayed out MS Access 2010 1
import from ms access table name unknown 1
data merge 0

Back
Top