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

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
 
J

John Vinson

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

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]
 

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

Top