Reading a CSV text file and storing the values in Oracle Database table

shafi2all · 04-17-2008, 09:31 AM

Hello,

I want a C programme to read a CSV text file and store the values in table(Oracle database).. when i execute this c-executable the values would read from CSV and transferred to a table present in Oracle..How could i do that?

Shafi

MensaWater · 04-17-2008, 10:14 AM

Haven't used it but it looks like this might be what you want or at least give you ideas about how to do it since the source for what he is doing is available:

http://opencsv.sourceforge.net/

TB0ne · 04-17-2008, 10:21 AM

If you want to break it down into steps:

- Check for the .CSV file you're wanting to open
- If its present, open it
- Connect to your database
- Read each line of the file, splitting the different fields at the commas
- Insert the record(s) into the database, until you hit EOF
- Close the database connection
- Exit

I've done things like this in Perl, using MySQL as the back end, and can usually do it in just a few lines of code. Haven't played with C in quite a while, though.

sunils1973 · 04-17-2008, 12:19 PM

In MySQL the LOAD DATA statement can be used to import text from a csv file to a table

ORACLE has also such a command to load data

I think create C program for this purpose is not required