Here is a data type mapping from MS Access native data types to application generic data types. Any data type not listed in this table is mapped to Other generic data type.
| Native data type | Generic data type |
| dbBigInt | Number |
| dbBinary | Binary |
| dbBoolean | Boolean |
| dbByte | Number |
| dbChar | String |
| dbCurrency | Number |
| dbDate | DateTime |
| dbDateExtended | DateTime |
| dbDecimal | Number |
| dbDouble | Number |
| dbFloat | Number |
| dbInteger | Number |
| dbLong | Number |
| dbLongBinary | Binary |
| dbMemo | String |
| dbNumeric | Number |
| dbSingle | Number |
| dbText | String |
| dbTimeStamp | DateTime |
| dbVarBinary | Binary |
Last updated: 2023-10-10
