How to autolink Excel file in Access 2010Locked
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.