ADO Equivalents to Access Data Types : ADO Data Type « Access « VBA / Excel / Access / Word






ADO Equivalents to Access Data Types

 
Microsoft Access Data Type     ADO Equivalent
Binary                         adBinary
Boolean                        adBoolean
Byte                           adUnsignedTinyInt
Currency                       adCurrency
Date                           adDate
Numeric                        adNumeric
Double                         adDouble
Small Integer                  adSmallInt
Integer                        adInteger
Long Binary                    adLongBinary
Memo                           adLongVarWChar
Single                         adSingle
Text                           adWChar

 








Related examples in the same category

1.Create a table with ADOX.Table and ADO data type
2.adInteger and adWChar