The following table lists the most common data types used in Microsoft. NETFramework data types and OleDbType enumeration. Access type name database data type OLEDB type. NETFramework type member name text VarWCharDBTYPE_WSTRSystem.StringO
The following table lists the most common data types used in Microsoft Access and these data types, Microsoft. NET Framework data types, and OleDbType enumeration. Access type name database data type ole db type. NET Framework type member name text VarWChar DBTYPE _ WSTR System. String O
The following table lists the most common data types used in Microsoft Access and these data types, Microsoft. NET Framework data types, and OleDbType enumeration.
Access type name |
Database Data Type |
Ole db type |
. NET Framework type |
Member name |
Text |
VarWChar |
DBTYPE _ WSTR |
System. String |
OleDbType. VarWChar |
Remarks |
LongVarWCha r |
DBTYPE _ WSTR |
System. String |
OleDbType. LongVarWChar |
No.: byte |
UnsignedTinyInt |
DBTYPE _ UI 1 |
System. Byte |
OleDbType. UnsignedTinyInt |
Yes/No |
Boolean Value |
DBTYPE_BOOL |
System. Boolean |
OleDbType. Boolean |
Date/time |
Date and Time |
DBTYPE_DATE |
System. DateTime |
OleDbType. Date |
Currency |
Decimal |
DBTYPE_NUMERIC |
System. Decimal |
OleDbType. Numeric |
No.: decimal |
Decimal |
DBTYPE_NUMERIC |
System. Decimal |
OleDbType. Numeric |
No.: Double Type Value |
Double-click |
DBTYPE_R8 |
System. Double |
OleDbType. Double |
Automatic ID (copy ID) |
GUID |
DBTYPE_GUID |
System. Guid |
OleDbType. Guid |
Number: (copy ID) |
GUID |
DBTYPE_GUID |
System. Guid |
OleDbType. Guid |
Automatic number (long integer) |
Integer |
DBTYPE_I4 |
System. Int 32 |
OleDbType. Integer |
Number: (long integer) |
Integer |
DBTYPE_I4 |
System. Int 32 |
OleDbType. Integer |
OLE object |
LongVarBinary |
DBTYPE_BYTES |
System. Byte array |
OleDbType. LongVarBinary |
No.: Single type value |
Single |
DBTYPE_R4 |
System. Single |
OleDbType. Single |
No.: Integer value |
Smallint |
DBTYPE_I2 |
System. Int 16 |
OleDbType. SmallInt |
Binary |
Varbinary * |
DBTYPE_BYTES |
System. Byte array |
OleDbType. Binary |
Hyperlink |
VarWChar |
DBTYPE _ WSTR |
System. String |
OleDbType. VarWChar |