Data Transfer from Access To Oracle

jessen · July 13th, 2006, 02:57 AM

Hi!!! I need to transfer all the data from a database access to an oracle database using visula basic 6.0 as intermediate..... Can anyone please help me about how to do it??? THXS...

Iturea · July 19th, 2006, 04:15 PM

Well the only things you really need to concern yourself with is the Provider and the data types. One function can pull data out of Access using the Access data provider and then you can call another function to put the data into Oracle using an Oracle data provider. Oracle has different types and ways it stores data so you will need to study up on that. In other words, you may need to format a "Date" from Access differently before you store it in Oracle.