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.
精彩评论