How to export more data from excel in existing table (database) of MS Access?

[learning_grexcel]

I want to export some excel data into MS access. The problem is I have different excel files and I want it to be in single MS access database. How it can be done?
I first opened one excel file in MS access. Now I want more files to be added in the existing database.

 

[alansidman]

Do all of the Excel files have the same table (identical) layout?

Alan

 

[learning_grexcel]

Yes.......

 

[alansidman]

The easiest way is to import each file using the Access wizard into individual tables. Once you have imported each table, create and run an append query to append the original table with the contents of each imported table. Finally, delete all the imported tables except the first one.

Alan