id="info"

General discussion

Locked

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.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
0 total posts (Page 1 of 1)  

Software Forums