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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anergy - 14 Apr 2005 01:33 GMT

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

Reply to this Message

John Vinson - 14 Apr 2005 06:32 GMT

>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]

Reply to this Message