Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

Linking Excel and Access

Posted by Wesley on December 22, 2000 6:00 AM

I have a spreadsheet with each employees name and productivity information. I'd like to create reports in Access without having to import the information from Excell each time I want to run a report. Is there an easy way to enter data in Excell and have it stored in Access automaticly?

Thank you in advance.

Re: Linking Excel and Access

Posted by cpod on December 22, 2000 6:27 AM

Instead of importing the excel table into Access you can link to it. The table would remain in Excel and Access would be able to retrieve any new data entered into it.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.