Merging 4 tables

Cindy_B

Registered User.
Local time
Today, 00:03
Joined
Dec 9, 2002
Messages
12
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
 

Users who are viewing this thread

Back
Top Bottom