Consolidating databases access
Anyone who can give me step by step on this please?
I would greatly appreciate and paste will work if they are identical, you can also export and import as a csv. Create csv file, open with excel copy single line and paste to mdb.
So as you can see there are a number of ways that work just fine hmm, the easiest way to do this, assuming you havent already done it.
While each file is structured the same, the information within sheet 1 and 2 (for example) is different.
So it can’t be combined into one file with everything in one sheet!
This will work if your table doesent have similar rows.
If you need to merge similar rows together, there is no a simple way to tho this.
Just close the source wookbook and do it again with the next one, until you've collected all the worksheets you care about into one large wookbook. Would you like to answer one of these unanswered questions instead?