Access-数据类型与.net OleDbType枚举类型对应关系
列表最常见的数据类型映射
| 访问类型名称 | 数据库数据类型 | OLEDB 类型 | .NET 框架类型 | 成员名称 |
| 文本 | VarWChar | DBTYPE _ WSTR | System.String | OleDbType.VarWChar |
| 备忘录 | LongVarWCha R | DBTYPE _ WSTR | System.String | OleDbType.LongVarWChar |
| 字节数: | UnsignedTinyInt | DBTYPE _ UI 1 | System.Byte | OleDbType.UnsignedTinyInt |
| 是 / 否 | Boolean | DBTYPE_BOOL | System.Boolean | OleDbType.Boolean |
| 日期 / 时间 | DateTime | DBTYPE _ DATE | System.DateTime | OleDbType.date |
| 货币 | 十进制 | DBTYPE_NUMERIC | System.Decimal | OleDbType.numeric |
| 十进制数: | 十进制 | DBTYPE_NUMERIC | System.Decimal | OleDbType.numeric |
| 双数: | 双 | DBTYPE_R8 | System.Double | OleDbType.Double |
| Autonumber （复制 ID） | GUID | DBTYPE_GUID | System.Guid | OleDbType.guid |
| 复制 (ID) 号: | GUID | DBTYPE_GUID | System.Guid | OleDbType.guid |
| Autonumber （长整型） | 整数 | DBTYPE_I4 | System.Int 32 | OleDbType.integer |
| 数量: （长整型） | 整数 | DBTYPE_I4 | System.Int 32 | OleDbType.integer |
| OLE 对象 | LongVarBinary | DBTYPE_BYTES | 数组 System.Byte | OleDbType.LongVarBinary |
| 单个数字： | 单个 | DBTYPE_R4 | System.Single | OleDbType.single |
| 整型数: | SmallInt | DBTYPE_I2 | System.Int 16 | OleDbType.SmallInt |
| 二进制 | VarBinary * | DBTYPE_BYTES | 数组 System.Byte | OleDbType.binary |
| 超链接 | VarWChar | DBTYPE _ WSTR | System.String | OleDbType.VarWChar |
FAILED TO TRANSLATE SENTENCE 您必须创建此数据类型通过代码。
OLE DB Provider for Microsoft Jet 数据类型支持：
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbprovjet_data_type_support.asp (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbprovjet_data_type_support.asp)
OLE DB Provider for Microsoft Jet DBPROPSET_JETOLEDB_COLUMN 中提供程序特有的属性：
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbprovjet_provider_specific_properties_in_dbpropset_jetoledb_column.asp (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbprovjet_provider_specific_properties_in_dbpropset_jetoledb_column.asp)
OleDbType 枚举
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataOleDbOleDbTypeClassTopic.asp (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataOleDbOleDbTypeClassTopic.asp)
