Recent content by mandeepdhami4u

  1. M

    Import multiple excel files into single access table

    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...
  2. M

    Import multiple excel files into single access table

    Thanks Uncle Gizmo for all your replies. I am working on the same and will get back to you with what I am able to acheive. Cheers, Mandeep
  3. M

    Import multiple excel files into single access table

    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...
  4. M

    Import multiple excel files into single access table

    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...
Back
Top Bottom