KS DB Merge Tools logo KS DB Merge Tools
Documentation
KS DB Merge Tools for Cross-DBMS logo for Cross-DBMS
 
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
AccdbMerge logo

MS Access data types

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 typeGeneric data type
dbBigIntNumber
dbBinaryBinary
dbBooleanBoolean
dbByteNumber
dbCharString
dbCurrencyNumber
dbDateDateTime
dbDateExtendedDateTime
dbDecimalNumber
dbDoubleNumber
dbFloatNumber
dbIntegerNumber
dbLongNumber
dbLongBinaryBinary
dbMemoString
dbNumericNumber
dbSingleNumber
dbTextString
dbTimeStampDateTime
dbVarBinaryBinary

Last updated: 2023-10-10