Archive for November 4th, 2009

Microsoft Access Data Types

Posted by Le Kevin in Database on November 4, 2009

The following table shows the Microsoft Access data types, data types used to create tables, and ODBC SQL data types.

Microsoft Access data type Data type (CREATETABLE) ODBC SQL data type
BIGBINARY[1] LONGBINARY SQL_LONGVARBINARY
BINARY BINARY SQL_BINARY
BIT BIT SQL_BIT
COUNTER COUNTER SQL_INTEGER
CURRENCY CURRENCY SQL_NUMERIC
DATE/TIME DATETIME SQL_TIMESTAMP
GUID GUID SQL_GUID
LONG BINARY LONGBINARY SQL_LONGVARBINARY
LONG TEXT LONGTEXT SQL_LONGVARCHAR[2] SQL_WLONGVARCHAR[3]
MEMO LONGTEXT SQL_LONGVARCHAR[2] SQL_WLONGVARCHAR[3]
NUMBER (FieldSize= SINGLE) SINGLE SQL_REAL
NUMBER (FieldSize= DOUBLE) DOUBLE SQL_DOUBLE
NUMBER (FieldSize= BYTE) UNSIGNED BYTE SQL_TINYINT
NUMBER (FieldSize= INTEGER) SHORT SQL_SMALLINT
NUMBER (FieldSize= LONG INTEGER) LONG SQL_INTEGER
NUMERIC NUMERIC SQL_NUMERIC
OLE LONGBINARY SQL_LONGVARBINARY
TEXT VARCHAR SQL_VARCHAR[1] SQL_WVARCHAR[2]
VARBINARY VARBINARY SQL_VARBINARY

via: http://msdn.microsoft.com/en-us/library/ms714540%28VS.85%29.aspx

via: http://www.sunfinedata.com/tips/create-an-ms-access-database-by-asp-vbscript/

Share|

, , ,

No Comments