By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,657 Members | 1,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,657 IT Pros & Developers. It's quick & easy.

Combine (Merge) Data from Two Access Tables

P: n/a
We have set up an Access database with tables x,y, & z where we would
like to have multiple people entering data into a table x. Each person
has an identical copy of the database on their PC's. When the person
is done entering the data into table x, we want them to e-mail their
database to one person who will combine the data from table x into a
single database.

What's the easiest method to combine the tables into a single table?

Thanks!

-Max

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
mojo wrote:
We have set up an Access database with tables x,y, & z where we would
like to have multiple people entering data into a table x. Each person
has an identical copy of the database on their PC's. When the person
is done entering the data into table x, we want them to e-mail their
database to one person who will combine the data from table x into a
single database.

What's the easiest method to combine the tables into a single table?

Thanks!

-Max


I'd add a field to TableX called Exported. It could be a boolean or a
date field. Maybe a date field would be better.

Then run a MakeTable query to select all records where Exported is Null
(or if they need to rerun it, for a date range). Maybe create a
database to hold the table that will be e-mailed to you.

They e-mail it to you. You save to a folder...maybe specific to the
user. Then run an append query from the folder of the user. You might
want to first create a query to select all records not in your
production table (so you stop an append process from being run multiple
times from the same table). Then run the append query from that list.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.