DataTypeEnum Enumeration (DAO)

dbAttachment

101

Attachment data

dbBigInt

16

Big Integer data

dbBinary

9

Binary data

dbBoolean

1

Boolean (True/False) data

dbByte

2

Byte (8-bit) data

dbChar

18

Text data (fixed width)

dbComplexByte

102

Multi-valued byte data

dbComplexDecimal

108

Multi-value decimal data

dbComplexDouble

106

Multi-value double-precision floating-point data

dbComplexGUID

107

Multi-value GUID data

dbComplexInteger

103

Multi-value integer data

dbComplexLong

104

Multi-value long integer data

dbComplexSingle

105

Multi-value single-precision floating-point data

dbComplexText

109

Multi-value Text data (variable width)

dbCurrency

5

Currency data

dbDate

8

Date value data

dbDecimal

20

Decimal data (ODBCDirect only)

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

dbDouble

7

Double-precision floating-point data

dbFloat

21

Floating-point data (ODBCDirect only)

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

dbGUID

15

GUID data

dbInteger

3

Integer data

dbLong

4

Long Integer data

dbLongBinary

11

Binary data (bitmap)

dbMemo

12

Memo data (extended text)

dbNumeric

19

Numeric data (ODBCDirect only)

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

dbSingle

6

Single-precision floating-point data

dbText

10

Text data (variable width)

dbTime

22

Data in time format (ODBCDirect only)

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

dbTimeStamp

23

Data in time and date format (ODBCDirect only)

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

dbVarBinary

17

Variable Binary data (ODBCDirect only)

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.