Server class MSACCESSODBC

Access databases are stored in a .mdb file. Using the ODBC manager, create an ODBC data source and map it to one of these files. A new .mdb file can be created through the ODBC manager. This database file becomes the default if you don't specify a different default when you create a table through SQL Anywhere.

Assuming an ODBC data source named access, you can use any of the following statements to access data:

CREATE TABLE tab1 (a int, b char(10))
AT 'access...tab1';

CREATE TABLE tab1 (a int, b char(10))
AT 'access;d:\\pcdb\\data.mdb;;tab1';

CREATE EXISTING TABLE tab1
AT 'access;d:\\pcdb\\data.mdb;;tab1';

Access does not support the owner name qualification; leave it empty.

Data type conversions: Microsoft Access

SQL Anywhere data type	Microsoft Access default data type
BIT	TINYINT
VARBIT(n)	if (n <= 4000) BINARY(n) else IMAGE
LONG VARBIT	IMAGE
TINYINT	TINYINT
SMALLINT	SMALLINT
INTEGER	INTEGER
BIGINT	DECIMAL(19,0)
UNSIGNED TINYINT	TINYINT
UNSIGNED SMALLINT	INTEGER
UNSIGNED INTEGER	DECIMAL(11,0)
UNSIGNED BIGINT	DECIMAL(20,0)
CHAR(n)	if (n < 255) CHARACTER(n) else TEXT
VARCHAR(n)	if (n < 255) CHARACTER(n) else TEXT
LONG VARCHAR	TEXT
NCHAR(n)	Not supported
NVARCHAR(n)	Not supported
LONG NVARCHAR	Not supported
BINARY(n)	if (n <= 4000) BINARY(n) else IMAGE
VARBINARY(n)	if (n <= 4000) BINARY(n) else IMAGE
LONG BINARY	IMAGE
DECIMAL(precision, scale)	DECIMAL(precision, scale)
NUMERIC(precision, scale)	DECIMAL(precision, scale)
SMALLMONEY	MONEY
MONEY	MONEY
REAL	REAL
DOUBLE	FLOAT
FLOAT(n)	FLOAT
DATE	DATETIME
TIME	DATETIME
TIMESTAMP	DATETIME
TIMESTAMP WITH TIMEZONE	CHARACTER(254)
XML	XML
ST_GEOMETRY	IMAGE
UNIQUEIDENTIFIER	BINARY(16)

Discuter à propos de cette page dans DocCommentXchange.