Insert Dataset into Database?

[Shurijo]

What is the best/fastest way to dump an entire dataset into an existing database? (going into MS Access)

I have a blank Access MDB that I want to make a new table and just dump the contents of my dataset, etc.

thanks,

[Pirate]

Set the connection string , open the connection to database . Declare new dataset , dataadapter , datarow objects like this :

Dim mydataset As New DataSet()
MyAdapter.Fill(mydataset, TableStr)
Dim MyDataRow As DataRow = mydataset.Tables(TableStr).NewRow
MyDataRow("Column1") = ctrls0.Text
MyDataRow("Column2") = ctrls1.Text
MyDataRow("Column3") = ctrls2.Text
MyDataRow("Column4") = ctrls3.Text
mydataset.Tables(TableStr).Rows.Add(MyDataRow)
MyAdapter.Update(mydataset, TableStr)

[Shurijo]

Ex: MyExistingDS has 1000 records pulled via ODBC Connection to Oracle DB, next I want to dump that ds to Access.

So I need to loop through each row in myExistingDS to populate the newDS?