Pull Fields From Multiple Tables

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

Guest

Hi:

I have "inherited" an Access Database that has several hundred tables. I don't know why it was setup this way...but it had to be a beginner that did it. Each table is identical in terms of the fields it has:

Name
Address


Is there a "quick" way I can pull these 2 fields from all the tables into one master table or query???

Thanks

Warren Phillips
 
If you want a permanent solution, use multiple Append queries to update a
single table.

You can use Union queries to get the contents of multiple tables at once,
but there's a limit as to how many tables you can Union together in a single
query.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



WDP said:
Hi:

I have "inherited" an Access Database that has several hundred tables. I
Click to expand...
don't know why it was setup this way...but it had to be a beginner that did
it. Each table is identical in terms of the fields it has:
 
Back
Top