Hello, might anyone have a good example of an Excel program that handles the CRUD operations to and from an SQL Server or Oracle database?
I would basically like to create an Excel program using .NET/VSTO or maybe even VBA, that would be similar to the following 2 products which handle the CRUD operations to and from external databases:
http://www.excel-db.net/
http://celigo.com/products/netsuite/excel-smartclient/ (handles referential integrity)
Or if anyone has a working VSTO or VBA Excel program that updates a single database table that would be great also and my long term goal is to basically use Excel be able to point Excel to any database and use Excel for the CRUD operations.
Thanks very much for any pointers or insights!
bk
I would basically like to create an Excel program using .NET/VSTO or maybe even VBA, that would be similar to the following 2 products which handle the CRUD operations to and from external databases:
http://www.excel-db.net/
http://celigo.com/products/netsuite/excel-smartclient/ (handles referential integrity)
Or if anyone has a working VSTO or VBA Excel program that updates a single database table that would be great also and my long term goal is to basically use Excel be able to point Excel to any database and use Excel for the CRUD operations.
Thanks very much for any pointers or insights!
bk
