By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,253 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,253 IT Pros & Developers. It's quick & easy.

LINKING excel to access 2003

P: 105

I have a question. I have a small database that keeps track of work that a contractor is doing for my company. Once a month I attach the database in an email and send it to the contractor so that they can enter some numbers in a couple of text boxes. Once they enter their information, they re-attach the database to an email and send it back to me.

There's GOT to be a simpler way to do this. Can't they just send me a spreadsheet every month with a couple of numbers in it? Someone told me that there is a way to do a linked table to excel from my database to "update" the numbers.

Any help would be greatly appreciated!

Thanks in advance.
Feb 15 '08 #1
Share this Question
Share on Google+
1 Reply

Scott Price
Expert 100+
P: 1,384
In Access 2003:

File Menu>Get External Data>Link Tables. This opens a dialog box allowing you to browse to the spreadsheet you wish to link to (You need to choose the .xls option at the bottom of the dialog box where it filters which files to display). This opens the Link Tables Wizard which will guide you through the rest of the process.

Good luck!

Feb 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.