Copy Database structure from Oracle 10g to Access 2007

I want to copy Full Database from Oracle 10g to Access 2007.

That meaning copy Tables, Relationship between tables

Can any body help me
interbusAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
could you please clarify why you want to do that?
also, what size is that oracle database?
0
HoggZillaCommented:
I will tell you how I would do it, using SQL Server Integration Services. SSIS.
Copy the Oracle db to SQL Server first, then to Access. Or I might try to go directly from Oracle to Access directly. But probably not.
0
kuknoCommented:
Hi,

you can import data directly via ODBC from other databases to MS Access. See here for a simple example:

http://www.pervasive.com/library/docs/psql/910/usrguide/usrguide-03-6.html#wp92146

All you need is to setup an ODBC connection to your Oracle database. See the oracle docs for this, or ask the Oracle DBA to help you.

Regards
Kurt
0
interbusAuthor Commented:
Good answer kukno

I know this way to import data directly

but I need to pring all tables with relationship identification on oracle

this way only import tables without relations

kukno you near to get 500 points but give me what I want
0
ee_autoCommented:
Question PAQ'd, 500 points refunded, and stored in the solution database.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.