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 do not specify a different default when you create a table through Sybase IQ.
Assuming an ODBC data source named access, create a table for it in one of these ways:
CREATE TABLE tab1 (a int, b char(10)) AT 'access...tab1'
or
CREATE TABLE tab1 (a int, b char(10)) AT 'access...tab1'
or
CREATE TABLE tab1 (a int, b char(10)) AT 'access;d:\pcdb\data.mdb;;tab1'
or
CREATE EXISTING TABLE tab1 AT 'access;d:\pcdb\data.mdb;;tab1'
Access does not support the owner name qualification. Leave it empty.
