My boss brought me this problem: (this could have been avoided from the beginning but he didn't think it important, so here I am stuck with the issue)
Anyway, there are 4 tables. Some field names are the same, some slightly different. I have to assemble all of the data into one table. I plan on the long way-copy the whole database, then change field names to match one by one the append into one. Is this the fastest/simplest way?

Thanks!

Cindy

You don't need to change the column names. Designate one of the databases as the master and link the other tables to that one. Then create append queries that select columns from the linked tables and append them to columns in the "master" table.

1. Open QBE and add the "from" table to the grid.
2. Select all the columns that you want from that table.
3. Change the query type to Append.
4. Access will automatically populate any append to cells where the column names match. You'll need to set each of the others manually.
5. Run the append query.