Merging Data bases in Access

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

Guest

I have three registration databases. Each record has an id_number.

Each of the three databases have different additional columns.

I want to generate a new table from the the original three.

The most current database is the master for using its id_number records and
I need to get the other tables additional columns into the new database.

I have done a query that accomplishes what I want, but I have been unable to
save it as a new table.

Thank you for your assistance,
Michael
 
You can change the query to a make table query and that will create a new
table. If you cannot modify the query, you can create a new query that
selects all the columns of your existing query and make that new query a
make table query.
 
Unfortunately I am receiving an "Invalid arguement." after it spends 20
minutes sorting, which is what I was receiving trying other ways. Either
there is a glitch in the program or their is something about the files that
Access does not like.
 
Append each table to the consolidation table one at a time rather than
merging them all together before appending.
 
Pat,

Thank you for your assistance. I have found the problem as the database was
too large to make in the same MDB file. I had to make a new MDB file and
combine the tables with a Make Table query into the new file. It appears
that my table single table is now to large and I will have to invetigate
allowing the MDB file to exceed the current 2.1 GigaBytes.
 
Back
Top