Import Access Data

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

Guest

I have a database located in another state which contains invoice data and
this data will be exported and sent to me so i can import it in my copy of
the same structure DB. I have not tried this before so i am at a loss as to
the easiest way for the data to populate fields such as the primary keys. I
have looked at the switchboard option that lets you export data to excell but
is there another way if both DB have the same structure?
 
you might ask the person at the other end to open a new Access db, import
the table(s) you need, and send you that db. on your end, just link the
table(s) into your db, and run an Append query from each linked table into
the matching table in your db.

hth
 
Back
Top