how to export oracle schema into access

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
imranhad
Posts: 56
Joined: Thu Apr 06, 2006 6:57 am
Location: Pakistan

how to export oracle schema into access

Post by imranhad »

supose i want to see scott schema in access with data
so how can i export into access.
thanks
Top
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:
Contact ahmadbilal

Post by ahmadbilal »

you can do this by two diffrent ways
a-Creating Dblink ,use HSODBC (Search On Oracle metalink)
b-GO In access and GET EXTERNAL DATA ---Import in file menu
Top
Post Reply

Return to “Oracle Databases”



Who is online

Users browsing this forum: No registered users and 1 guest