1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Dim db As DAO.Database 'Database to import
Dim tdf As DAO.TableDef
Dim arrTablename As Variant, arrSourceName As Variant, strSourceConnect As String, i As Long
arrTablename = Array("Activite", "RaisonSociale", "Region", "Site")
arrSourceName = Array("Activités", "Raison_sociale", "Region", "Site")
Dim strCheminBd As String, strNomTable As String, strMotPasse As String
strCheminBd = "P:\Repertoire\base1.mdb"
strMotPasse = "pass"
strSourceConnect = "MS Access;PWD=" & strMotPasse & ";DATABASE=" & strCheminBd
Set db = CurrentDb
' créer les tables
For i = LBound(arrTablename) To UBound(arrTablename)
Set tdf = db.CreateTableDef(arrTablename(i), dbAttachSavePWD + dbAttachedTable, arrSourceName(i), strSourceConnect)
tdf.RefreshLink
db.TableDefs.Append tdf
Set tdf = Nothing
Next i |
Partager