1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| 'Import/Export des tables fouilles dans la base courante vers la base destination
Namedb_Data = DLookup("Chemin", "Chemins", "Fonction='Données'") & "\" & Replace(Base, ".accdb", "_Data.accdb")
With rstA
Do While .EOF = 0
MoveTable = !LaTable
'import
Forms!PgBar!Ptxt = "Importation données céramique..." & " (" & MoveTable & ")"
Forms!PgBar!Pct = Int(rstA.PercentPosition) / 100
DoCmd.TransferDatabase acImport, "Microsoft Access", Namedb_Data, acTable, MoveTable, "TMP_" & MoveTable
DoEvents
'export
Forms!PgBar!Ptxt = "Exportation données céramique..." & " (" & MoveTable & ")"
Forms!PgBar!Pct = Int(rstA.PercentPosition) / 100
DoCmd.TransferDatabase acExport, "Microsoft Access", Namedb_Ceram, acTable, "TMP_" & MoveTable, MoveTable
DoEvents
SupprimerTable ("TMP_" & MoveTable)
.MoveNext
Loop
.Close
End With |
Partager