Excel- Access DB Connection

[slraik]

Hi All,

I have created a database and have a folder that stores about 100 excel files.

I want to dump the data present on each excel file to a unique table in access.

Primarily Im concerned to store the data from 5 worksheets of each excel to this data base.

Any starting help hand on this please?

[alansidman]

Do you want the data from all 100 files in one table, or are you looking to have 100 separate tables (actually, 500 tables if you are looking to have each worksheet in its own table)?