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: Generic Connectivity

Re: Generic Connectivity

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Mon, 8 Sep 2003 15:15:18 GMT
Message-ID: <3F5C9D06.3CFB3EBF@remove_spam.peasland.com>


Basically...

  1. Create an ODBC DSN to connect to your Oracle database.
  2. Start MS Access
  3. Choose File->Get External Data->Import
  4. In Files Of Type, choose ODBCDataSources()
  5. Double-click on your DSN
  6. Enter username/pswd if prompted
  7. Select table(s) from list and choose OK

Thats it!

HTH,
Brian

Braddini wrote:
>
> i saw this thread and was wondering what are the full steps to take to
> connect to an access db and its table?

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

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 Mon Sep 08 2003 - 10:15:18 CDT

Original text of this message

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