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 45 46 47 48 49 50
|
Private Sub ConnecterBase(ConnectBD As ADODB.Connection, _
Fichier As String)
Set ConnectBD = New ADODB.Connection
With ConnectBD
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = Fichier
.Open
End With
End Sub
Private Sub CreerTable()
Dim ConnectBD As ADODB.Connection
Dim Catalogue As ADOX.Catalog
Dim ChaineSQL As String
Dim NomBase As String
Set Catalogue = New ADOX.Catalog
'adapter le chemin
NomBase = "D:\Dossier1\MaBase.mdb"
ConnecterBase ConnectBD, NomBase
Catalogue.ActiveConnection = ConnectBD
'définir la chaine SQL, ici 4 champs
ChaineSQL = "CREATE TABLE NomDeLaTable ( "
ChaineSQL = ChaineSQL & "ID CHAR(10) WITH COMP PRIMARY KEY, "
ChaineSQL = ChaineSQL & "Nom CHAR(20) WITH COMP NULL, "
ChaineSQL = ChaineSQL & "Prenom CHARACTER(20) NOT NULL, "
ChaineSQL = ChaineSQL & "Age DATE); "
With ConnectBD
.Execute ChaineSQL
.Close
End With
Set Catalogue = Nothing
Set ConnectBD = Nothing
End Sub |
Partager