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!
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!