export/update from excel workbook to access database file

[sparshsam]

Hi All

I need some code or sample files

I want to export my multiple excel workbooks to one access database file using excel & VBA

Thanks A lot in Advance

[ndendrinos]

Welcome to this forum sparshsam.
You did not receive an answer for over two weeks so I'll stick my neck out and say:

There are several ways to do this but before any of the experts here offer a solution you will have to give more details.

Are all worksheets in all workbooks setup in the same way?
Do the columns have headers?

If the answer is yes then you could use code to consolidate all sheets of all workbooks into one new workbook in sheet1 and then export the whole thing in Access.

Maybe you could post a sample of one workbook ?