ADO data type conversion table
http://www.able-consulting.com/adodatatypeenum.htm
The Following Table Shows The Ado Data Type Mapping Between Visual Basic, Access, SQL Server, Oracle, And The .NET Framework.
View Printable Version
ADODataTypeEnumADODataTypeEnumValue.NETFrameworkSQLServerSizeAccessOracleVisualBasic6.0adBigInt20Int64SqlDbType.BigInt 10OleDbType.BigInt 11bigint 98 VariantadBinary128Byte [] SqlDbType.VarBinary 10OleDbType.Binary 11binarytimestamp508 Raw 7 VariantadBoolean11BooleanSqlDbType.Bit 10OleDbType.Boolean 11bit12 YesNo BooleanadBSTR8StringOleDbType.BSTR 11 adChapter136 (DataReader) adChar129String SqlDbType.Char 10OleDbType.Char 11charX CharStringadCurrency6DecimalSqlDbType. Money 10OleDbType.Currency 11moneysmallmoney 840 Currency CurrencyadDate7DateTimeOleDbType.DBDate 11 0 DateTime 2 DateadDBDate133DateTimeOleDbType.DBDate 11 adDBFileTime137DBFileTime 11 adDBTime134DateTimeOleDbType.DBTime 11 adDBTimeStamp135DateTimeSqlDbType.DateTime 10OleDbType.DBTimeStamp 11datetime smalldatetime 840 DateTime 1DateDateadDecimal14DecimalOleDbType.Decimal 11 Decimal 7 Variant 6adDouble5DoubleSqlDbType.Float 10OleDbType.Double 11float 80 DoubleFloatDoubleadEmpty0Empty 11 a dError10External-ExceptionOleDbType.Error 11 adFileTime64DateTimeOleDbType.Filetime 11 adGUID72Guid SqlDbType.UniqueIdentifier 10OleDbType.Guid 11uniqueidentifier516 ReplicationID2,3 VariantadIDispatch9ObjectOleDbType.IDispatch 11 adInteger3Int32SqlDbType.Int 10OleDbType.Integer 11 identity 4int 44 AutoNumberLong IntegerInt 7 LongadIUnknown13ObjectOleDbType.IUnknown 11 adLongVarBinary205Byte [] SqlDbType.VarBinary 10OleDbType. Longvarbinary 11Image2147483647 oleobjectlong raw 7blob 8variantadlongvarchar201stringsqldbtype.varchar 10oledbtype.longvarchar 11text2147483647 Memo 1, 2HyperLink 1,
2Long 7Clob 8StringadLongVarWChar203StringSqlDbType.NText 10OleDbType.VarWChar 11ntext 51073741823 Memo 3Hyperlink 3NClob 8StringadNumeric131DecimalSqlDbType.Decimal 10OleDbType.Decimal 11decimalnumeric 9 Decimal 3DecimalIntegerNumberSmallIntVariant 6adPropVariant138ObjectOleDbType.PropVariant 11 adSingle4SingleSqlDbType.Real 10OleDbType.Single 11real4 Single SingleadSmallInt2Int16, SqlDbType.SmallInt 10OleDbType.SmallInt 11smallInt2 Integer IntegeradTinyInt16ByteOleDbType.TinyInt 11 adUnsignedBigInt21UInt64OleDbType .UnsignedBigInt 11 adUnsignedInt19UInt32OleDbType.UnsignedInt 11 adUnsignedSmallInt18UInt16OleDbType.UnsignedSmallInt 11 adUnsignedTinyInt17ByteSqlDbType.TinyInt 10OleDbType.UnsignedTinyInt 11tinyInt1 Byte ByteadUserDefined132 adVarBinary204Byte [] SqlDbType.VarBinary 10OleDbType.VarBinary 11varbinary50 ReplicationID 1 VariantadVarChar200StringSqlDbType.VarChar 10OleDbType.VarChar 11varcharX Text 1, 2VarCharStringadVariant12ObjectSqlDbType.Vari ant 10OleDbType.Variant 11sql_variant 98016 VarChar2VariantadVarNumeric139OleDbType.VarNumeric 11 adVarWChar202StringSqlDbType.NVarChar 10OleDbType.VarWChar 11nvarchar 5X Text 3NVarChar2StringadWChar130StringSqlDbType.NChar 10OleDbType.WChar 11nchar 5X StringTop of Page
