Link table with Excel file

[ScottXe]

I would like to link a couple of columns of an Excel file with a table in my database for further manipulation. The Excel file is exported from other department manually every day. How can I set this up to accomplish the task? Thanks!

 

[boerbende]

Create linked table based on your Excel file in Access
Afterwards you can treat the Excel table as a regular table and you can query it