Import tables from Oracle 10g

[JL]

Can anyone tell me how to import tables from Oracle 10g?

TIA,
John

 

[Jeff Boyce]

You'll need a way to connect to the Oracle database. Have you looked at
ODBC drivers?

 

[JL]

Hi Jeff,
I have not looked at ODBC yet. I was hoping there might be an export
functionality in Oracle that would get me to Access. I simply want to
take the data and schema from Oracle and create the same tables in
Access.

Thanks,
John

 

[Jeff Boyce]

Perhaps one of the other 'group readers knows what Oracle can do. I know
that SQL-Server has that kind of functionality, so I'm guessing Oracle does
too.

Have you tried an Oracle newsgroup?

 

[Lynn Trapp]

The simplest way would be to create a linked table in Access to your Oracle
table. That would give you dynamic access to the Oracle data. If you need to
simply import it then you could run a Create Table statement like this:

Create Table YourAccessTable
As
Select * From YourLinkedOracleTable;

The user you connect to the Oracle database with will need to have, at
least, Select (in my experience, an Oracle DBA isn't going to want to give
you more than that for an Access link anyway) on the table you are linking.


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html