How to autolink Excel file in Access 2010

Search Close

Account Information

Reset password

An email has been sent to you with instructions on how to reset your password.

Back to TechRepublic

Welcome to TechRepublic!

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

All fields are required. Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

General discussion

Creator

Topic
October 12, 2012 at 1:14 pm #2170485

How to autolink Excel file in Access 2010

Locked

by seasona · about 9 years, 11 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 conversation is currently closed to new comments.
Creator

Topic

All Comments

Start or Search

Start New Discussion

This document helps make sure that you address data governance practices for an efficient, comprehensive approach to data management. This checklist from TechRepublic Premium includes: an introduction to data governance, a data governance checklist and how to manage a data governance checklist. From this checklist’s introduction: Data governance is the process by which an organization ...

Recruiting a Scrum Master with the right combination of technical expertise and experience will require a comprehensive screening process. This hiring kit provides a customizable framework your business can use to find, recruit and ultimately hire the right person for the job. This hiring kit from TechRepublic Premium includes a job description, sample interview questions ...

Knowing the terminology associated with Web 3.0 is going to be vital to every IT administrator, developer, network engineer, manager and decision maker in business. This quick glossary will introduce and explain concepts and terms vital to understanding Web 3.0 and the technology that drives and supports it.

Software

General discussion

How to autolink Excel file in Access 2010

All Comments

Data governance checklist for your organization

How to recruit and hire a Scrum Master

Web 3.0 quick glossary

How to recruit and hire a User Experience Designer