Updating an Excel File using a Textbox

See more:

VB

MS-Excel

OleDb

Right now I'm able to pull in data from a single cell in an excel file using the oledataadapter and a textbox. However when I change the data using the textbox the changes don't save to the excel file. Here is my code below, if anyone can figure out how I might save the changes made from the textbox I would be ecstatic!

MyCommand1 = New OleDbDataAdapter("select * from [myWorksheet$B3:B4]", MyConnection)

        ds1 = New System.Data.DataSet()
        MyCommand3.Fill(ds1)

        


       

        '---This is the code to display the data to the textbox,
        'however I still haven't figured out how to save the data back to the excel file'
        TextBoxView1.Text = ds1.Tables(0).Rows(0)(0).ToString