ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Modifying a database based on changes in an Excel document (https://www.excelbanter.com/excel-programming/366151-modifying-database-based-changes-excel-document.html)

shai-hulud

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


Norman Jones

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