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
| Private Sub fraImportProd_Click()
'Mise en place du sablier
DoCmd.Hourglass True
'Lancement de l'importation de la base REELLE
DoCmd.TransferDatabase acImport, "Base de données ODBC", "ODBC;DSN=GGA60;", acTable, "none.ARTST", "none_ARTST"
' Suppression de la table déjà présente
DoCmd.DeleteObject acTable, "none_ARTST"
' Renommage de la table importée
DoCmd.Rename "none_ARTST", acTable, "none_ARTST1"
DoCmd.TransferDatabase acImport, "Base de données ODBC", "ODBC;DSN=GGA60;", acTable, "none.CDIPP", "none_CDIPP"
DoCmd.DeleteObject acTable, "none_CDIPP"
DoCmd.Rename "none_CDIPP", acTable, "none_CDIPP1"
DoCmd.TransferDatabase acImport, "Base de données ODBC", "ODBC;DSN=GGA60;", acTable, "none.HALOA_DET", "none_HALOA_DET"
DoCmd.DeleteObject acTable, "none_HALOA_DET"
DoCmd.Rename "none_HALOA_DET", acTable, "none_HALOA_DET1"
DoCmd.TransferDatabase acImport, "Base de données ODBC", "ODBC;DSN=GGA60;", acTable, "none.PLMAT", "none_PLMAT"
DoCmd.DeleteObject acTable, "none_PLMAT"
DoCmd.Rename "none_PLMAT", acTable, "none_PLMAT1"
DoCmd.Hourglass False
End Sub |
Partager