General discussion

Locked

Linking MS-Excel Spreadsheet

By tptbusines_98 ·
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 conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by davebkelly In reply to Linking MS-Excel Spreadsh ...

I am thinking back now as I have not used 97 for quite a while but I think that It is possible to link Access tables to external data.

1, Make a note of the network path of the spreadsheet.
2, Open a new database
3, Goto File / Get External Data / Link Files.
4, Then find your spreadsheet.
5, You should see a formatting type wizard to help you format the link properly.

This should show up in your Access tables as an Excel spreadsheet and any changes made to the spreadsheet will then be reflected in Access. However, look out for file locks !!!

I am kind of sure that this will work in 97 for you but like I say, its been a little while since I used it. If not......Upgrade !!!

Collapse -

by tptbusines_98 In reply to Linking MS-Excel Spreadsh ...

"Thank You", but will this apply for Internet/Intranet...

Back to Windows Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums