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

 

[orange]

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 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.