Export data to access from files in excel

[DreamKid]

I have many excel files that each holds one customer purchases identified by
an ID number. I need to creat a database that contains all sold item ID
numbers from all customers. Is there anyway to export this information from
all files to one database in access? all files are in one folder. I have
about 25 excel files.
Thank you

 

[PieterLinden via AccessMonster.com]

I have many excel files that each holds one customer purchases identified by
an ID number. I need to creat a database that contains all sold item ID
numbers from all customers. Is there anyway to export this information from
all files to one database in access? all files are in one folder. I have
about 25 excel files.
Thank you

You can use DIR() to loop through all the Excel files in a folder. Then you
can use TransferSpreadsheet to import the data into your database.

Check out Ken Snell's website:
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm

if you look up DIR in the VBA help, you should find an example... post back
if you need more help.