Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: link table

Re: link table

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Wed, 29 Oct 2003 15:22:20 GMT
Message-ID: <3F9FDB2C.4E4DA670@remove_spam.peasland.com>


Create a DSN to your Oracle database using your Oracle ODBC driver.

> File ->Get external data -> link tables

Then, in the Files Type pull down box, scroll to the bottom and select "ODBC() Datasources". Then select your DSN you created above. After supplying the userid/password, you will be presented with a list of tables. Select the ones you want to link to your Access database.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Wed Oct 29 2003 - 09:22:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US