The Microsoft Jet database engine SQL data types consist of 13 primary data types defined by the Microsoft Jet database engine and several valid synonyms recognized for these data types.
The following table lists the primary data types. The synonyms are identified in Microsoft Jet Database Engine SQL Reserved Words.
| Data type | Storage size | Description |
| BINARY | 1 byte per character | Any type of data may be stored in a field of this type. No translation of the data (for example, to text) is made. How the data is input in a binary field dictates how it will appear as output. |
| BIT | 1 byte | Yes and No values and fields that contain only one of two values. |
| BYTE | 1 byte | An integer value between 0 and 255. |
| COUNTER | 4 bytes | A number automatically incremented by the Microsoft Jet database engine whenever a new record is added to a table. In the Microsoft Jet database engine, the data type for this value is Long. |
| CURRENCY | 8 bytes | A scaled integer between – 922,337,203,685,477.5808 and 922,337,203,685,477.5807. |
| DATETIME (See DOUBLE) |
8 bytes | A date or time value between the years 100 and 9999. |
| GUID | 128 bits | A unique identification number used with remote procedure calls. |
| SINGLE | 4 bytes | A single-precision floating-point value with a range of – 3.402823E38 to – 1.401298E-45 for negative values, 1.401298E-45 to 3.402823E38 for positive values, and 0. |
| DOUBLE | 8 bytes | A double-precision floating-point value with a range of – 1.79769313486232E308 to – 4.94065645841247E-324 for negative values, 4.94065645841247E-324 to 1.79769313486232E308 for positive values, and 0. |
| SHORT | 2 bytes | A short integer between – 32,768 and 32,767. |
| LONG | 4 bytes | A long integer between – 2,147,483,648 and 2,147,483,647. |
| LONGTEXT | 1 byte per character | Zero to a maximum of 1.2 gigabytes. |
| LONGBINARY | As required | Zero to a maximum of 1.2 gigabytes. Used for OLE objects. |
| TEXT | 1 byte per character | Zero to 255 characters. |
Note You can also use the VALUE reserved word in SQL statements.