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 | |