The Table Below Shows The ADO Data Type Mapping Between Access, SQL Server, And Oracle:
DataType EnumValueAccessSQLServerOracleadBigInt20 BigInt (SQL Server 2000 ) adBinary128 BinaryTimeStampRaw * adBoolean11YesNoBit adChar129 CharCharadCurrency6CurrencyMoneySmallMoney adDate7DateDateTime adDBTimeStamp135DateTime (Access 97 (ODBC)) DateTimeSmallDateTimeDateadDecimal14 Decimal * adDouble5DoubleFloatFloatadGUID72ReplicationID (Access 97 (OLEDB)), (Access 2000 (OLEDB)) UniqueIdentifier (SQL Server 7.0 ) adIDispatch9 adInteger3AutoNumberIntegerLongIdentity (SQL Server 6.5) Int Int * adLongVarBinary205OLEObjectImageLong Raw * Blob (Oracle 8.1.x) adLongVarChar201Memo (Access 97) Hyperlink (Access 97) TextLong * Clob (Oracle 8.1.x) adLongVarWChar203Memo (Access 2000 (OLEDB)) Hyperlink (Access 2000 (OLEDB)) NText (SQL Server 7.0 ) NClob (Oracle 8.1.x) adNumeric131Decimal (Access 2000 (OLEDB)) DecimalNumericDecimalIntegerNumberSmallIntadSingle4SingleReal adSmallInt2IntegerSmallInt adUnsignedTinyInt17ByteTinyInt adVarBinary204ReplicationID (Access 97) VarBinary adVarChar200Text (Access 97) VarC Harvarcharadvariant12 SQL_VARIANT (SQL Server 2000 ) VARCHAR2ADVARWCHAR202TEXT (Access 2000 (OLEDB)) NVARCHAR (SQL Server 7.0 ) NVARCHAR2ADWCHAR130 NCHAR (SQL Server 7.0 )
* In Oracle 8.0.x - Decimal and Int Are Equal to Number and Number (10).
