b r a y d e n . o r g / Software

/ WebHome / MicrosoftPages / AdoDataTypes

This Web


WebHome  
Topic List  
Web Statistics 

All Webs


Books
Main
Random
Software
TWiki  

brayden.org


Home
Monthly Digest
Today's Links
Resumé
Reading List
Books RSS
Random RSS
Software RSS

Other


Dale's Blog

currently-reading
TextDrive

A table of mappings between the datatypes provided by Microsoft Access, SQL Server, and ADO.

ADO Data Types

Mapping of field types between Access, SQL Server, and ADO

MS Access SQL Server ADO Constant
Yes/No Bit adBoolean
Number(Byte) TinyInt adTinyInt
Number(Integer) SmallInt adSmallInt
Number(Long Integer) Int adInteger
Number(Single) Real adSingle
Number(Double) Float adDouble
Currency Money adCurrency
- Smallmoney adCurrency
Decimal/Numeric Decimal adDecimal
- Numeric adNumeric
Date/Time Datetime adDate
- Smalldatetime adDBDate
AutoNumber Int adInteger
Text(n) Varchar(n) adVarchar
- Nvarchar(n) adVarchar
Memo Text adLongVarWChar
OLE Object Image adLongVarBinary
Replication ID Uniqueidentifier adGUID

 
 
Edit | Attach | Ref'd By | Printable | More | Advanced Search | Full Text Topic Name

Current Rev: r1.1 - 03 Dec 2005 - 15:58 GMT - DaleBrayden, Revision History:Diffs | r1.1
© 2003-2011 by the contributing authors.