Can Access import excel files in a folder just like Excel's power query?

Copper Contributor

Hey, I am new with access and I used to use Excel for my business needs. However, I am currently trying to use Access. So far, I am looking for a way to import excel files in a folder which can be refreshed regularly; since the files in the folder keeps on updating each day. In each folder contains xls files which using excel can be easily appended. Can I use similar function in Access? Thank you.

1 Reply
If the Excel file names stay the same, then why not just LINK to the Excel files instead of importing them.
By doing that, you will always have the latest Excel files available in Access