inserting to one database from another

[pfildes]

Hi,

I am trying to insert records from one database to another.

I am passing in a SourceDataSet created from the SourceDatabase and a DestinationDatabaseConnection (that is open). I just need to know how to put the SourceDataSet into the destination database. (the table exists in the destination and has the same field names)

i am trying something like below, however i am not sure how the syntax of the parameter needs to be to reference the columns of the source dataset or if that is how to do it.

Dim dbDataAdapter As New SqlDataAdapter

dbDataAdapter.InsertCommand = New SqlCommand
dbDataAdapter.InsertCommand.Connection = dbDestinationConnection
dbDataAdapter.InsertCommand.CommandText = "INSERT INTO DestTable "
"(DestCol1, DestCol2) "
"VALUES (@Col1, @Col2)" dbDataAdapter.InsertCommand.Parameters.AddWithValu e("@Col1", dbSourceDataSet.Tables("Table").Columns("Col1"))
dbDataAdapter.InsertCommand.Parameters.AddWithValu e("@Col2", dbAccessDataSet.Tables("Association").Columns("Col 2"))
dbDataAdapter.InsertCommand.ExecuteNonQuery()