I am thinking of using VSTO 2005 to program Excel as a front to enter data to a sql server or access database. I have not been able to find any examples from books or the web. Can someone give me some pointers as to how I can proceed? I have seen quite a few examples on how to pull data out. But I have yet to come across an example to put data in!
Can VSTO 2005 use ADO.NET?
Thanks for the help.

The process is fairly straightforward. Build your front end with your client as a spreadsheet and add a submit or update button. In the click event handler, retrieve the contents of the range object in the spreadsheet and build a query. The book, Professional VSTO 2005, contains sample code to show you how to retrieve data from the range object.

As far as binding directly to the database, VSTO doesn't currently support this.

>Can VSTO 2005 use ADO.NET?
ADO.NET is platform agnostic. Any managed code, to include VSTO can access the ADO.NET layer.

I can bind an Excel spread sheet to a database and 'browse' through the data using VSTO
I just don't know how to enter data from the same spreadsheet to the database that I was able to bind.
Do I have to create a rangename to accept the input and use it as a parameter to a stored procedure to insert?

Thanks.