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 SAP Sybase IQ.
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.
SAP Sybase IQ 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) |