How to Combine Three Tables into One Table????

N

Norm Stahl

Aloha,
I have similar mailing list data in three different tables
(because they came from three different sources) and would
like to combine them into a single table. . . How do I
acomplish this?????
NSS
 
R

Ron Boyer

-----Original Message-----
Aloha,
I have similar mailing list data in three different tables
(because they came from three different sources) and would
like to combine them into a single table. . . How do I
acomplish this?????
NSS
.
I always use an append query to do this. You have to do
Click to expand...
one query for each different table. Are you just
combining the data once, or is it an ongoing process? If
it is ongoing, run the queries in a macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to combine two tables into one table 2
Combine and Insert query 7
VBA - retrieve data on last create named range from previous inserted named range 0
Access Sorting and grouping using multiple tables 0
Three or on table ? 7
I am trying to combine three separate lists into one, how do I do 2
Combing databases 1
Import into Access from Excel 2

Top