MSAccess - Automatic excel file upload (1 Viewer)

[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?

 

[Uncle Gizmo]

I answered a similar question in 2008, see here:-

Import multiple excel files into single access table

Hello, I have some data in excel which I am importing it into MS Access 2002. Each excel file (one worksheet per file) is imported into separate tables. I want to combine all my imported tables into one table. Is that possible, if yes then how and if no then what can be done to get single...

www.access-programmers.co.uk

Might offer some inspiration...