access查询所有表名和字段的方法在我的文章自己找。下面是各个字段值的对应类型。
EMPTY 0
SMALLINT 2
INTEGER 3
SINGLE 4
DOUBLE 5
CURRENCY 6
DATE 7
BSTR 8
IDISPATCH 9
ERROR 10
BOOLEAN 11
VARIANT 12
IUNKNOWN 13
DECIMAL 14
TINYINT 16
UNSIGNEDTINYINT 17
UNSIGNEDSMALLINT 18
UNSIGNEDINT 19
BIGINT 20
UNSIGNEDBIGINT 21
GUID 72
BINARY 128
CHAR 129
WCHAR 130
NUMERIC 131
USERDEFINED 132
DBDATE 133
DBTIME 134
DBTIMESTAMP 135
CHAPTER 136
VARCHAR 200
LONGVARCHAR 201
VARWCHAR 202
LONGVARWCHAR 203
VARBINARY 204
LONGVARBINARY 205