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 |