SQL Server/Access数据类型对照表
2011-1-5 12:47:44 - tanlixiao
SQL Server/Access数据类型对照表，给大家用Access数据库新建表时，设置字段有个参考
以下是SQL Server / Access数据类型对照表
SQL Server 7 data type ADO data type Enum value
binary adVarBinary
bit adBoolean
char adChar
datetime adDate
decimal adNumeric
float adDouble
int adInteger
money adCurrency
nchar adWChar
ntext adLongVarChar
numeric adNumeric
nvarchar adVarWChar
real adSingle
smalldatetime adDate
smallint adSmallInt
text adLongVarChar
timestamp adBinary
tinyint adUnsignedTinyInt
UniqueIdentifier adGUID
varBinary adVarBinary
varChar adVarChar
备注,我觉得应该是对应oledbtype.longvarchar---LongVarChar或者LongVarWChar