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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to join 2 tables with the same structure in access 1

Status
Not open for further replies.

domxp

Technical User
Feb 18, 2002
25
PL
Hi everyone!

My question is stupid, though I cannot find a solution studying carefully help files. I imported two huge datasets to access and I got two tables now. Both tables however are of the same structure. Both of them contain exactly the same kind of data, but from different periods (two years). Instead of having them separatly, I'd like to have only one with all data?
1. How shall I do it?
2. If I went back in the process, is there any way to import additional data to existing table (like if I had one improted, might I import data from another source into the existing table directly)?
Please if you only can, answer both questions.

Thanks in advance!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top