I am having a problem trying to undate a Dataset in Excel to an Access data base. I am using VSTO 2005 with office 2003. This is the code I am trying to use but it errors and tells me that Validate and Update are not a member of Workbook.sheet1 Sheet1 is where I have the button. Obviously I am missing something but being I am a VBA guy trying to learn .net I am having some problems.

Thanks for any help.
Tom Hallmark

Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click

        Try
            Me.Validate()
            Me.TRgraphBindingSource.EndEdit()
            Me.TRgraphTableAdapter.Update(Me.TRgraphDBDataSet. TRgraph)
            MsgBox("Update successful")

        Catch ex As Exception
            MsgBox("Update failed")
        End Try
    End Sub

T,

It is a good idea to post a question in more than one formu (gets more exposure).
But when you do that, post the text of the question in one place, copy the URL to the question, and just post the URL in the other fora. That way all traffic on the question will be in one place.
(It's not too late to switch this questio to that mode. You can edit the additional postings.)

Thank you. Maybe I should explain a little better what I am trying to do.
In vs.2005 tools for office. I am connecting an excel workbook to a data base by dragging and dropping the dataset onto the excel sheet. It populates correctly and when I select the data in the combo box the list updates correctly. Now I want to make changes to the list box and update it in the database by clicking a button(or automatically would work) So far I have the next/previous fields to work but I cannot figure how to update. Everything I have read says to use the tableadapter update that does not seem to work.

Sure would appreciate any help.

Tom