MSAccess - Automatic excel file upload

[akika]

Hi,
I want to automatically load multiple excel files save in one folder to respective access tables:

customers.xlsx (id, name, address, street, phone, email)
sales.xlsx (sales id, description)
product.xlsx (product_id, product_name, comments)
orders.xlsx (order_id, order_date, order_by)

Excel & tables are same format.

Can you pls advise to automate the loading of all files, with an access sample if possible.
Txs

 

[arnelgp]

why not just Link the xlsx files?
after linking, you create an Insert query that will
insert records from the Linked xlsx file to your table.

 

[akika]

why not just Link the xlsx files?
after linking, you create an Insert query that will
insert records from the Linked xlsx file to your table.

do u have a sample for how to do it pls?