Importing data from another access database to an existing table

  • Thread starter Thread starter Tan
  • Start date Start date
T

Tan

There are 2 people currently doing data entry into an access database (each
of them have their own identical database file on their computer) and I
currently hold the master file. I am trying to import their data into the
master database existing tables.
How can I do that? When I try to import, Access just create a new table with
a number after it. (for example, event table is the master table and when I
import someone in a new table is created with their data titled "event1")

In addition, in the database there are 3 tables that are linked together, I
would like to import it so that they stay together.

Does anyone have any suggestions?

Thank you!!!!
 
also in addition, i tried copy and paste between the tables :) it did not
work for some reason. sadly, I did not design this database
 
How are you importing the data?

If it were up to me, I'd prefer to split the database and put a copy
of the front end on each user's computer, keeping the back end on a
network drive.

Otherwise, in Access 2000, I think you would use an append query to
add the data in event1 to your main table.

If you import the table each time, it seems that you'd get duplicate
data in your main table.

I would query the tables in each user's computer for only new data to
temp tables in the master database.

I'd use an update query to put the import date in a new field called
importdate so I would know which data to import.

Dan
 
Back
Top