I have an excel spreadsheet that I have as a linked table within Access. That excel spreadsheet updates on a daily basis. I have another table within access that is pulling information out of the linked excel table. I have a query set up that will update the information in the existing table from the linked excel table.
Is there any way I can have this query automatically run every night? Or is there a way that I can have the query automatically update when I open the program?