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
| If Existe(Nom_Table) Then 'And Existe("ALMR_" & Nom_Table) Then
If bool Then DoCmd.RunSQL "delete * from [" & Nom_Table & "];"
Set rs = cn.Execute("SELECT * FROM " & Nom_Table & " WHERE partition_key = '" & DAR & "0000' and (import_source like '%_888%' or import_source like '%_PTF01')")
Set Rst1 = Application.CurrentDb.OpenRecordset(Nom_Table, dbOpenTable, dbConsistent, dbOptimistic)
If Not rs.EOF Then
While Not rs.EOF
Rst1.AddNew
For i = 0 To rs.Fields.count - 1
TempC = rs(i).Name
If (Not IsNull(rs(TempC))) Then
If Rst1(i).Type = dbDate Then
On Error Resume Next
Rst1(TempC) = rs(TempC)
If Err.Number <> 0 Then
Rst1(TempC) = CDate("01/01/0100")
Err.Clear
End If
On Error GoTo erreur
Else
Rst1(TempC) = rs(TempC)
End If
End If
Next i
Rst1.Update
rs.MoveNext
Wend
End If
rs.Close
Rst1.Close
Else
MsgBox "La table " & Nom_Table & " n'a pu être mise à jour car elle est introuvable dans la base Access!", vbExclamation, "Erreur"
End If |
Partager