General discussion


How to autolink Excel file in Access 2010

By seasonA ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums