Update Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with two different databases; however, the newer database contains information needed from the older database. Is there a way to copy the information I need from one database to another.

Example
The primary key is the PROV ID#, I need to copy there address into the current database without manually typing them.
 
Use the 'File'-'Get External Data'-'Import' option built into Access.
Navigate to the old database, select it and pick the tables you want to import.
A copy of the table will then appear in your tables list.
 
Back
Top