CSV file to database

[Patrick Mugabe]

I want to update a csv file to my database. Can you help with ideas. I am not sure how it's done.
[ August 30, 2006: Message edited by: Patrick Mugabe ]

[Patrick Mugabe]

For those who might face the same problem, there's an open source csvJdbc driver that can be used. It reads from the cvs then you can use your ordinary JDBC java code to insert into your database table

[Ulf Dittmer]

Is the problem the reading or writing of CSV files, or the DB access? If the former, have a look at a library that can work with CSV files, like the Ostermiller Utils.
[ August 30, 2006: Message edited by: Ulf Dittmer ]

[Scott Selikoff]

CSV files are pretty easy to read, you might want to consider just writing a simple JDBC based script that performs the update manually.