Microsoft KB Archive/320435

= INFO: OleDbType Enumeration vs. Microsoft Access Data Types =

Article ID: 320435

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft ADO.NET 1.0
 * Microsoft ADO.NET 1.1
 * Microsoft Visual Studio .NET 2002 Professional Edition
 * Microsoft Visual Studio .NET 2003 Professional Edition
 * Microsoft Visual Studio .NET 2002 Enterprise Architect
 * Microsoft Visual Studio .NET 2003 Enterprise Architect
 * Microsoft Visual Studio .NET 2002 Enterprise Developer
 * Microsoft Visual Studio .NET 2003 Enterprise Developer
 * Microsoft Visual Studio .NET 2002 Academic Edition
 * Microsoft Visual Studio .NET 2003 Academic Edition

-



This article was previously published under Q320435



SUMMARY
This article describes how the Microsoft .NET Platform OLE DB types map to the Microsoft Access data types for columns.



MORE INFORMATION
When you use the Access interface to design a table, you see several choices for field types that do not match to database data types. This is because these &quot;types&quot; are just display formats and do not determine the data type. Access uses other properties that are not necessarily exposed through the Microsoft OLE DB Provider for Jet to determine how to format the data.

Examples of these properties include the following:
 * General Date, Long Date, Long Time, Medium Time, Short Time, Medium Date, and Short Date are display formats for DateTime data type.
 * Hyperlink is a display format for Access Text data type.
 * True/False and On/Off both map to the Access Yes/No data type.

List of the Most Common Data Type Mappings
The following table lists the most common data types that are used in Microsoft Access and how these data types relate to the Microsoft .NET Framework data types and to the OleDbType enumeration.


 * This data type is not available in the Access designer user interface. You must create this data type through code.

