=======================================================================================
create table 中的类型 | ACCESS 2000 中的字段类型
---------------------------------------------------------------------------------------
Byte | 数字(字节)
---------------------------------------------------------------------------------------
SmallInit | 数字(整型)
---------------------------------------------------------------------------------------
Int | 数字(长整型)
---------------------------------------------------------------------------------------
Long | 数字(长整型)
---------------------------------------------------------------------------------------
Single | 数字(单精度型)
---------------------------------------------------------------------------------------
Double | 数字(双精度型)
---------------------------------------------------------------------------------------
Numeric | 数字(双精度型)
---------------------------------------------------------------------------------------
Currency | 货币型
---------------------------------------------------------------------------------------
Money | 货币型
---------------------------------------------------------------------------------------
Text(10) | 文本,字段大小为 10
---------------------------------------------------------------------------------------
YesNo | 是/否型,相当于逻辑型
---------------------------------------------------------------------------------------
Date | 日期/时间型
---------------------------------------------------------------------------------------
Memo | 备注型
=======================================================================================
create table 中的类型 | ACCESS 2000 中的字段类型
---------------------------------------------------------------------------------------
Byte | 数字(字节)
---------------------------------------------------------------------------------------
SmallInit | 数字(整型)
---------------------------------------------------------------------------------------
Int | 数字(长整型)
---------------------------------------------------------------------------------------
Long | 数字(长整型)
---------------------------------------------------------------------------------------
Single | 数字(单精度型)
---------------------------------------------------------------------------------------
Double | 数字(双精度型)
---------------------------------------------------------------------------------------
Numeric | 数字(双精度型)
---------------------------------------------------------------------------------------
Currency | 货币型
---------------------------------------------------------------------------------------
Money | 货币型
---------------------------------------------------------------------------------------
Text(10) | 文本,字段大小为 10
---------------------------------------------------------------------------------------
YesNo | 是/否型,相当于逻辑型
---------------------------------------------------------------------------------------
Date | 日期/时间型
---------------------------------------------------------------------------------------
Memo | 备注型
=======================================================================================
浙公网安备 33010602011771号