Import a CSV file to H2
194 views
Skip to first unread message
Oana
Oct 9, 2009, 5:05:19 AM10/9/09
to H2 Database
Hello,
For our Java Application ( a server connected to a databse) I am
considering changing from the current database (Derby) to H2.
But I don't know how to import data collected in a CSV format from my
old DB into H2 using SQL commands
(rather than writing a script that will read the CSV and call the
INSERT command for each line).
Thank you,
Oana
For our Java Application ( a server connected to a databse) I am
considering changing from the current database (Derby) to H2.
But I don't know how to import data collected in a CSV format from my
old DB into H2 using SQL commands
(rather than writing a script that will read the CSV and call the
INSERT command for each line).
Thank you,
Oana
Oana
Oct 9, 2009, 5:32:26 AM10/9/09
to H2 Database
I found the answer to my question in an older post :)
("Which SQL statements to write to import this kind of text file
( quotes ), into a H2 database ? " )
("Which SQL statements to write to import this kind of text file
( quotes ), into a H2 database ? " )
Reply all
Reply to author
Forward
0 new messages