Modifying a database based on changes in an Excel document
Hello,
I use an Excel document that someone else programmed. I am trying to figure out if it is possible to have a database like Access store the information that the spreadsheet is displaying, then if changes are made in the spreadsheet, it would dynamically update the database (without the spreadsheet needing to be saved). Is this possible? Is there a website that explains how to do this? Thanks, Neil |
Modifying a database based on changes in an Excel document
Hi Neil,
See Ole P. Erlandsen at: http://www.erlandsendata.no/english/...badacexportado and http://www.erlandsendata.no/english/...badacexportdao --- Regards, Norman "shai-hulud" wrote in message oups.com... Hello, I use an Excel document that someone else programmed. I am trying to figure out if it is possible to have a database like Access store the information that the spreadsheet is displaying, then if changes are made in the spreadsheet, it would dynamically update the database (without the spreadsheet needing to be saved). Is this possible? Is there a website that explains how to do this? Thanks, Neil |
All times are GMT +1. The time now is 11:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com