General discussion
June 18, 2006 at 02:37 PM
tptbusines_98

Linking MS-Excel Spreadsheet

by tptbusines_98 . Updated 20 years, 1 month ago

Hello,
I’ve inherited an MS-Excel 97 spreadsheet, as a data-entry sheet. I need to import & link the spreadsheet into an MS-Access 97 database.
I need to keep the spreadsheet as a “data-entry” sheet, because of the mass amount of data it contains, & the number of people using the spreadsheet. 1. How can I link the spreadsheet to an MS-Access 97 database? 2. Is it possible to convert the spreadsheet to be Internet/Intranet compatible?? 3. If it is possible to convert the spreadsheet, how & how do I maintain the link to the MS-Access 97 database??? Can someone point me to an example/sample(s) of my request???

Thank you,
Charles L. Phillips

This discussion is locked

All Comments