connecting mssql to access and oracle

How do i connect from mssql to access database and oracle
A good example would be fine
I would like to use ODBC or any free tools
THANKS
SEJCreate a linked server or use openquery/openrowset.

Access shold be easy as you should already have the driver but will need to install the oracle connectivity layer for oracle.|||Originally posted by nigelrivett
Create a linked server or use openquery/openrowset.

Access shold be easy as you should already have the driver but will need to install the oracle connectivity layer for oracle.

Can you give some details
I have sql developer 2000 and oracle9i and access on the same machaine with 2000 professional
Novice i am in connectivity issues
with example will help

SJ