Hello

I have a csv file and i want to read data from it and pass the data to the database.

Now.

I have values that are seperated with semicolons.

The file is like this.

customerID;name;surname;phoneNumber

1;Gokhan;Terzioglu;333444333
2;Melih;Terzioglu;555444333


There are 100.000 columns like this. How can I read the data effectively?

I also don't know how to read from csv file. The problem here seems that the columns are seperated with semicolons instead of commas...

Hi,

You can use the opencsv library. It will help in read/write csv files.
It also has constructors that let you supply your own seperator. i.e. you can specify semicolon as the seperator

http://opencsv.sourceforge.net