How to autolink Excel file in Access 2010 - TechRepublic
General discussion
October 12, 2012 at 01:14 PM
seasona

How to autolink Excel file in Access 2010

by seasona . Updated 13 years, 8 months ago

I need to link an Excel file to my Access database. File name changes daily. Example: filename I need to link today is: Name20121011.xls. Tomorrow the file name will change to Name201212.xls.
What I do now is in Excel I do a Save As Name.xls to copy over my current day file. My Access database then picks up that Name.xls.
Is there an easier way for me to do this rather than doing a Save As in Excel everyday? Thank you.

This discussion is locked

All Comments