Reading A CSV Then Writing To Oracle Database

Question

Hi all,

I need to be able to read in a CSV and then write all data back to a specified table within Oracle.

At the moment, I have put the following Oracle connection together, but need to read in c:\test.csv for example.

OracleConnection importOraConn = new OracleConnection();
            importOraConn.ConnectionString = "User Id=USERNAME,Password=PASSWORD;Data Source=ORACLEDB";
            importOraConn.Open();
            OracleCommand importOraCommand = importOraConn.CreateCommand();
            OracleDataAdapter oda = new OracleDataAdapter(importOraCommand);

Any help with this would be greatly appreciated.


Thanks