开发者

Excel OleDb Data Types

Does anyone have a list of data types I can use in a CREATE TABLE statement for Exc开发者_如何转开发el? I have searched and cannot come up with anything; at least not anything official. From one place, I found:

CHAR(255)
MEMO
INT
DATE
TIME

What about other numeric types? DECIMAL, etc? DATETIME (together)?

Thanks in advance.


Be careful: Excel natively supports only the the following data types (so any other data type will be converted to one of these)

Double precision floating point (this handles integers, longs, dates, times, currency etc)
string
Boolean
Error


These data types can be formatted by the Excel renderer to look like currency, integer, date time etc.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜