ms access to oracle

[basti42]

hello!
i have data in ms access (.mdb) i want to transfer the data
in oracle how would i do that?

tnx

[jmcilhinney]

How do you get data from Access? Use a DataAdapter to populate a DataTable. How do you get data into Oracle? Use a DataAdapter to insert the contents of a DataTable.

You only need one DataTable, because it doesn't care where the data comes from or goes to. You only need one DataAdapter too, assuming you have an OLEDB provider for Oracle installed. You just need two Connections: one each for the SelectCommand (Access) and the InsertCommand (Oracle).

Just make sure you set the AcceptChangesDuringFill property of the DataAdapter to False. That way the RowState of each DataRow will remain Added and they will each get inserted into the Oracle database when you call Update.

[basti42]

ok, i'll remember now. thank you

[Hack]

Is this something that you are going to need to do on an ongoing basis?

If so, then I can see the need for writing code for it. However, if this is just a one time data migration thing, then doing a direct import using Oracle tools would seem a simpler approach.

[GaryMazzone]

If this is a one off run it is probably easiest to connect directly to Oracle from MS Access (using ODBC) and placing the data where you want it.