Get Data From CSV file and Insert it to Database??????

Inserting:

http://javaalmanac.com/egs/java.sql/InsertPs.html

following would allow your csv to be treated a a table allowing you to select from it, then insert into other

https://xlsql.dev.java.net/

heaps of database examples here

http://www.javaalmanac.com/egs/java.sql/pkg.html

you should be able to pick out what you need to do the copy

let me know if you have any questions :)

Hi all,

I would like to use pure Java instead of other ready made component/class.

I will try to look at the above info you guys send and see how can I
get the CSV value and insert into a table ..


I will get back to you all as soon as possible


Many thanks

kenneth

HI,

since my CSV file data are capture from a SQL table, so mean it has Fields name together with its value....SO can I do some filtering like:

when Bac_ID = 1234 then all it's records will be captured and insert into another table in a database

Can I filter that in a CSV file?

Pls advice

Thanks in advance
Kenneth

Please print an example of the file

sure, insdie your loop check the value of the column, and only insert it if it matches.

Output_Filename        | BaC_No    |
____________________________ |
F:\sony\1.txt      | 222        |
F:\sony\2.txt      | 134        |
F:\sony\3.txt      | 123        |
F:\sony\4.txt      | 123        |
----------------------------------------


above is the data format in CSV(excel format).

so if i check "Bac_NO=123" then get all to another table will I able to do that?  will it get row by row?


thanks

You just parse it row by row - you *know* what the fields are

Insert would look like

ps.setString(1, tokens[0]);
ps.setInt(1, Integer.parseInt(tokens[1]));

Sorry

ps.setInt(2, Integer.parseInt(tokens[1]));

still active question

>> still active question

What do still need help with?

Actually I encounter this prb where in my csv files
one of the field actually consists of multiple values.

The 3rd filed in my csv files consists of mulitple values that seperated by "an empty space" or "spacebar".
How am I going to read it and insert it into the table? In each row, one of the field will have mulitple values.

Pls assist me on this prb.

Thanks in advance
Keneth

how r u parsing your csv?

R94EAJ0000.pdf      2367      "21240949*
21242238*
21242433*
"      9300163309      Form      


======================================================

Hi above is basically my csv format layout. You possibly can copy and paste into ur Excel Sheet.
The "*" /asterisk is the area where "small box" beside the number is available. (I unable to show the "small box" here so i represent it using "asterisk").

There are 5 fields, and field #3 got 3 sub values on it.

So how am I going to read all this field especially field number 3 which has special character (small box)? Because I gonna append these field's value into db.

I don want to use third party classes.

Thanks

Hope can advice as I desperate for this answer after try n try several times.