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
| Set tblNew = New ADOX.Table
'Create a new Table object.
With tblNew
.Name = strTableName
'Ecriture de la structure de la table
For intI = 0 To 9
If aDatabase(intI).strNAME = "" Then
Exit For
End If
'Définition de la table
strFieldName = aDatabase(intI).strNAME
'Convertit les types de données en données Access
Select Case aDatabase(intI).strType
Case "Texte"
lngDefType = dbChar
'Longueur du champ
lngSize = CDbl(aDatabase(intI).strLen)
Case "Numerique Entier"
lngDefType = adInteger
Case "Numerique Decimal"
lngDefType = adDouble
Case "Date", "Heure"
lngDefType = adDBDate
Case "Heure"
lngDefType = adDBTime
Case "Oui/Non"
lngDefType = dbBoolean
End Select
' Créé le champ
.Columns.Append strFieldName, lngDefType, lngSize
Next
End With
' Add the new Table to the Tables collection of the database.
catDB.Tables.Append tblNew |
Partager