Bueno basicamente es este el proceso que hago, pero son muchas tablas a la vez.
Código vb:
Ver originalCall ConnectDatabaseLanmark()
Dim cmd12 As New Odbc.OdbcCommand
cmd12.Connection = Conection
cmd12.CommandText = "SELECT code, ""desc"" FROM MARKCAT"
cmd12.CommandType = CommandType.Text
Dim dr12 As Odbc.OdbcDataReader = cmd12.ExecuteReader()
While dr12.Read()
k = dr12.Item("code")
l = dr12.Item("desc")
Call ConnectDatabase()
Dim MyCommand12 As New SqlCommand
MyCommand12.Connection = MySqlConnection
MyCommand12.CommandText = "Insert INTO dbo.MARKCAT VALUES('" & k & "', '" & l & "' )"
MyCommand12.CommandType = CommandType.Text
MyCommand12.ExecuteNonQuery()
Call DisconnectDatabase()
End While
Muchas Graciaaaas por la ayuda.