The following table lists the Field data types.
DAO Field data type | Constant |
Big Integer | dbBigInt |
Binary | dbBinary |
Boolean | dbBoolean |
Byte | dbByte |
Char | dbChar |
Currency | dbCurrency |
Date/Time | dbDate |
Decimal | dbDecimal |
Double | dbDouble |
Float | dbFloat |
GUID | dbGUID |
Integer | dbInteger |
Long | dbLong |
Long Binary (OLE Object) | dbLongBinary |
Memo | dbMemo |
Numeric | dbNumeric |
Single | dbSingle |
Text | dbText |
Time | dbTime |
TimeStamp | dbTimeStamp |
VarBinary | dbVarBinary |