开发者

Excel OleDb Data Types

开发者 https://www.devze.com 2023-04-11 19:55 出处:网络
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

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

精彩评论

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