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