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,
Printable View
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,
Set the connection string , open the connection to database . Declare new dataset , dataadapter , datarow objects like this :
VB Code:
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)
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?