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
| Dim Chp_Champ1 As String
Dim Chp_Champ2 As String
Dim Chp_Champ3 As String
Dim Chp_Champ4 As String
Dim Chp_Champ6 As String
Do Until Rst.EOF = True
If IsNull(Rst.Fields(1).Value) Then
Chp_Champ1 = ""
Else
Chp_Champ1 = DbleApostr(Rst.Fields(1).Value)
End If
If IsNull(Rst.Fields(2).Value) Then
Chp_Champ2 = ""
Else
Chp_Champ2 = DbleApostr(Rst.Fields(2).Value)
End If
If IsNull(Rst.Fields(3).Value) Then
Chp_Champ3 = ""
Else
Chp_Champ3 = DbleApostr(Rst.Fields(3).Value)
End If
If IsNull(Rst.Fields(4).Value) Then
Chp_Champ4 = ""
Else
Chp_Champ4 = DbleApostr(Rst.Fields(4).Value)
End If
If IsNull(Rst.Fields(6).Value) Then
Chp_Champ6 = ""
Else
Chp_Champ6 = DbleApostr(Rst.Fields(6).Value)
End If
Import_sql = "Insert Into saisie (Champ, Champ1, Champ2, Champ3, Champ4, Champ6)"
Import_sql = Import_sql & "Values('" & Format(Rst.Fields(0).Value, "YYYY/MM/DD") & "',"
Import_sql = Import_sql & "'" & Chp_Champ1 & "', '" & Chp_Champ2 & "',"
Import_sql = Import_sql & "'" & Chp_Champ3 & "', '" & Chp_Champ4 & "', '" & Chp_Champ6 & "')"
Import_sql = Import_sql & "ON DUPLICATE KEY UPDATE Champ = '" & Format(Rst.Fields(0).Value, "YYYY/MM/DD") & "',"
Import_sql = Import_sql & "Champ1 = '" & Chp_Champ1 & "', Champ2 = '" & Chp_Champ2 & "',"
Import_sql = Import_sql & "Champ3 = '" & Chp_Champ3 & "', Champ4 = '" & Chp_Champ4 & "',"
Import_sql = Import_sql & "Champ6 = '" & Chp_Champ6 & "';"
cn.Execute (Import_sql), True
Rst.MoveNext
Loop |
Partager