Once you got a DSN defined in the ODBC manager that connects to your SQL Server, you can connect a normal MS Access document to the Oracle server, and link an Access table to a SQL Server table. The tutorial below gives you a good example:

* Start MS Access with a new database file.

* Go to File menu.

* Select Get External Data.

* Select Import.... The Import dialog box shows up.

* Select Files of type: ODBC Database(). The Select Data Source dialog box shows up.

* Click the Machine Data Source tab. You should see the DSN name "ggl_SQL_SERVER" you defined earlier.

* Select "ggl_SQL_SERVER".

* Enter User Name: sa.

* Enter Password: GlobalGuideLine.

Click the OK button to continue. You should see a list of tables available for you to import from the SQL Server as shown in the picture below:

MS Access importing tables via ODBC

Select the table you are interested in and click OK. You should the selected table being imported from the SQL Server to MS Access.