move data from Oracle table to MS access table

[bhagat.singh-j]

Guys,
I'm new to Visual basic.
My requirement is below:
I've a table in Oracle 9i and replica of the same table in MS access.
I need to move the data from Oracle 9i table to the corresponding table in MS access.
Can someone help me out with a Visual basic macro...or ideas please?

Thanks,
Bhagat

[GaryMazzone]

Link the Oracle table to MSAccess then use the Query table to create an append query to move the data from the Oracle table to the access table.

[mabbas110]

WEll u can use Data transformation services of SQL Server 2000 to do this

first import data from oracle to sql and then impport from sql to acess and u can do it trough code also , sql 2000 can make code for u , see DTS for more help

[Ecniv]

Or since you are in vb...

Open a recordset in ado to the oracle
Open a recordset in ado to access
Use a loop to read from one and write to the other.
Save.
Move to the next record.


Or even better - don't use access !! Oracle is faster and better - and if you are getting data from Oracle I expect it to be large!