MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


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.