Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
| OLE DB Programmer's Reference |
This table shows how a Microsoft Access provider might map its data types to OLE DB data types.
| Microsoft Access data type | OLE DB type indicator |
|---|---|
| BINARY (< 255 bytes) | DBTYPE_BYTES |
| BIT | DBTYPE_BOOL |
| BYTE | DBTYPE_UI1 |
| COUNTER | DBTYPE_I4 |
| CURRENCY | DBTYPE_CY |
| DATETIME | DBTYPE_DATE |
| DOUBLE | DBTYPE_R8 |
| GUID | DBTYPE_GUID |
| LONG | DBTYPE_I4 |
| LONGBINARY | DBTYPE_BYTES |
| LONGTEXT | DBTYPE_STR |
| SHORT | DBTYPE_I2 |
| SINGLE | DBTYPE_R4 |
| TEXT (< 255 bytes) | DBTYPE_STR |
1998-2001 Microsoft Corporation. All rights reserved.