Export data to access from files in excel

D

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
 
P

PieterLinden via AccessMonster.com

DreamKid said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top