Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Append multiple tables
- Thread starter Roosters
- Start date
Roosters,
I'm not sure exactly what you mean by combine. But if all the tables have the same basic type of data fields, ie they're a bunch of customer lists from different branch offices, and you have the same fields & data types (or close to the same), then a Union query will do the trick. Often just a little preliminary tweaking is needed here, such as lopping off un-common fields, or making sure the order of the fields is the same (or aliasing and listing them in the select clause of the union instead of using select *). Then use the union as the base for an append query to the destination.
--Jim
I'm not sure exactly what you mean by combine. But if all the tables have the same basic type of data fields, ie they're a bunch of customer lists from different branch offices, and you have the same fields & data types (or close to the same), then a Union query will do the trick. Often just a little preliminary tweaking is needed here, such as lopping off un-common fields, or making sure the order of the fields is the same (or aliasing and listing them in the select clause of the union instead of using select *). Then use the union as the base for an append query to the destination.
--Jim
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question
- Locked
- Question