Export data to access from files in excel

  • Thread starter Thread starter DreamKid
  • Start date Start date
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
 
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
Click to expand...

You could create a blank database in Access. Then, link each of the excel files to Access; or import each file into Access-- whichever s more appropriate for you.
Using Access queries you can create/adjust tables as necessary.
 
Back
Top