move data from Oracle table to MS access table

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

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.

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

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!