Oracle to Access...a long journey

[sagar_cool]

Hi friends

I need to transfer my database which is Oracle....into Access..i dont have much knowledge about oracle..how do i transfer the database from oracle to access?????

thx in advance
sagar

[mikeecc]

Hi sagar_cool,

If you are looking to write your own code to accomplish this task then you are quite correct .... its a long journey, I have done this numerous times.....

Look into all of the ADO - functions which are available - it will make the journey a lot shorter.


Mike

[hellomadhu]

it will be simple for u to use the import wizard in access 2k.

just create a dsn to oracle database and use the import wizard

to import the data