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) |