Importing Data from Another Database

  • Thread starter Thread starter Les Heifner
  • Start date Start date
L

Les Heifner

I have to add many clients from a backup database to the exisiting database.
When I attempt to export "Clients" into this newer database it tells me that
there already something called clients. My response is "yes." I merely want
to update the Client List.
 
Well, since what you really want to do is append to, not replace the Clients
table, that makes sense to me. In the existing database link the Clients
table in the backup database, using File | Get External Data | Link, and
create an append query to add the records. If you try to add records that
are already in the Clients table in the existing database, those will be
treated as errors, but the ones that are not there should be appended.

Once you have linked the Clients table in the backup database, use the Query
Builder to create a SELECT query... and once you are satisfied that it is
retrieving the records you want, on the menu Query | Append Query and
respond to the prompt with the name of the Clients table in the existing
database. That should do what you want.

Larry Linson
Microsoft Access MVP
 
Back
Top