Adding info to a table

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I have three tables. Each Table is in a different data base. What is the
easiest way to add Information from Table B and Table C to Table A in a
seperate database. I am using Access 2002 on an XP operating system. The
data is Table B and Table C can not already be in Table A. I hope I have
given you enough information.

thanks in advance for the help


Ray

--
 
Ray;

I believe the answer to your question is to "Link" the tables.

Click on File, click on "Get external data", click on "Link tables"

Navigate to the database you want to update from the active database,
double-click on that database's file name, then chose the table's name and
click on the Ok button.

I have a database I created years ago called "Work Tracker" I link it to
any new database that I'm working with to track my time and steps.

I also Imported the forms, (Click on File, click on "Get external data",
click on Import, navigate same as above) from the "Work Tracker" this way
the imput form is always the same no matter what database is being worked
on.

Andy
 
Back
Top