In Access, how can I merge remote data into the same database?

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

Guest

I made a bibliographic database and add to it from my laptop in the library.
When I try to import the data it just adds another database but won't add the
records to the master DB. Any help would be appreciated
 
I made a bibliographic database and add to it from my laptop in the library.
When I try to import the data it just adds another database but won't add the
records to the master DB. Any help would be appreciated
Click to expand...

How are you importing? Are both databases in Access, or in some other
storage medium?

If they're both Access (or Access-compatible databases such as SQL
Server), you can *link* to the remote database, and then run an Append
query to append the data to your local table.

John W. Vinson[MVP]
 
Back
Top