Access ing between Access data types and. NET Data Types

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