Hello Uncle Gizmo,
I am able to run the file that you gave in your attachement with your dummy tables in it. I tried changing the codes so that it picks up all the columns that I have in my table but was not able to succeed.
Can you please help me with changing the codes. I have got many...
Thanks Uncle Gizmo, your solution will work for me, but have few questions.
1) I am not able to add any new tables in your file with the solution.
2) I am also not able to delete sample 10 tables that is there in your solution.
3) I am using Access 2002 (SP3), will your solution work without...
Hello,
I have some data in excel which I am importing it into MS Access 2002. Each excel file (one worksheet per file) is imported into separate tables.
I want to combine all my imported tables into one table. Is that possible, if yes then how and if no then what can be done to get single...