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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help Oracle to Access

RE: Help Oracle to Access

From: David Wendelken <davewendelken_at_earthlink.net>
Date: Thu, 25 Aug 2005 22:45:39 -0400
Message-ID: <008901c5a9e8$3e90c8f0$6401a8c0@davidwendelken>

> They can use Access to Link to Oracle and import the tables.
> If they don't know how to do it then they shouldn't be using Access.
 

That was a bit less than helpful. Shame on you.  

> I know it seems backward but I got a request to
> move Oracle database to access. What is the easiest way to do this?
 

Access has an import facility, and it can use an odbc driver to pull the data from Oracle into Access.  

Right click on the "Tables" menu entry and choose Import. Make the file type ODBC. That will take you to a wizard that's pretty easy to fill in.    

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 25 2005 - 21:43:52 CDT

Original text of this message

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