1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
Private Sub CopiarTablaAccessEnSQLExpress()
Dim ComandoSQL As String = ""
Dim ConsultaSQL As String = ""
Dim MiComando As New SqlCommand
Dim MiDataTabla As New DataTable
ConexionSQLExpress.ConnectionString = CadenaConexionParaSQLExpress
ConexionSQLExpress.Open()
ConexionAccess1.ConnectionString = CadenaConexionParaAccess1
'ConexionAccess1.Open()
ConsultaSQL = "SELECT Id_Expediente, FechaRgto, Id_Usuario, Motivo, Explica, Open_Close FROM Hist_Expte"
Dim MiAdapter As OleDbDataAdapter = New OleDbDataAdapter(ConsultaSQL, ConexionAccess1)
MiAdapter.Fill(MiDataTabla)
ComandoSQL = "INSERT INTO Hist_Expte (Id_Expediente, FechaRgto, Id_Usuario, Motivo, Explica, Open_Close) VALUES (@param1, @param2, @param3,@param4, @param5, @param6)"
MiComando.Connection = ConexionSQLExpress
MiComando.CommandType = CommandType.Text
MiComando.CommandText = ComandoSQL
For I As Integer = 0 To MiDataTabla.Rows.Count - 1
MiComando.Parameters.AddWithValue("@param1", MiDataTabla.Rows(I).Item(0))
MiComando.Parameters.AddWithValue("@param2", MiDataTabla.Rows(I).Item(1))
MiComando.Parameters.AddWithValue("@param3", MiDataTabla.Rows(I).Item(2))
MiComando.Parameters.AddWithValue("@param4", MiDataTabla.Rows(I).Item(3))
MiComando.Parameters.AddWithValue("@param5", MiDataTabla.Rows(I).Item(4))
MiComando.Parameters.AddWithValue("@param6", MiDataTabla.Rows(I).Item(5))
MiComando.ExecuteNonQuery()
MiComando.Parameters.Clear()
Next
MiAdapter.Dispose()
MiComando.Dispose()
ConexionSQLExpress.Close()
ConexionSQLExpress.Dispose()
ConexionAccess1.Dispose()
' MessageBox.Show("Registros copiados")
End Sub |
Partager