combine access tables into one table

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

Guest

I would like to combine several access tables into one access table and then
utilize a search function in order to look up specific data
 
To combine them (assuming they have identical structures) you could use
append queries to add records to the table you wish to save from the ones
you will delete.

If you only wish to combine the data for the purpose of performing a search
(if you will not be deleting the tables) then you should not create a new
table, but rather create a union query which combines several tables' data
into one group of records that can be used in forms or reports, or can be
evaluated further. The query wizard will help you create a union query.

Rick B
 
Don't combine your tables! Use an Union Query. Look up Union Query in Help
file.
 
Thank you for the help! I have about 10 tables with only about 5 column
headings for data in each table. The article you referred me to says how to
join 2 tables in the query. Do you know if you can join that many tables in a
query an how it is done? Also, the data comprising the 10 tables is being
updated all day long. Will the query reflect this updated data?
 
Thank you for the help! I have about 10 tables with only about 5 column
headings for data in each table. Do you know if you can join that many
tables in a query an how it is done? Also, the data comprising the 10 tables
is being updated all day long. Will the query reflect this updated data?
 
Why don't you try it and see. Have you read the articles (or the help
file)? Have you tried to build one?

Help your self and THEN ask us if you need more help.

Rick B
 
<< know if you can join that many tables in a query >>
Yes

<< how it is done>>
Look up union queries in Help file

<<Will the query reflect this updated data>>
It will reflect the data that is in the table at the time the Union Query is
run.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
 
You must log in or register to reply here.

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

Combine Duplicates in Query 0
Combine and Insert query 7
How to export table from outlook into ms access table? 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Combining Tables 3
VBA - retrieve data on last create named range from previous inserted named range 0
Query design 0
Linked Tables - adding field and getting overflow error 1

Back
Top