Java and programmatically importing a csv into an SQLite3 table

Question

In Java how do I programmatically import a csv text file into a table of an SQLite3 database? Can this even be done with SQLite3's .import, for example IMPORT myFile myTable?

Kris · Accepted Answer · 2011-09-13 10:31:13Z

1

I guess you cannot execute the 'import' statement through JDBC, what you can do is to either use command line through Runtime.exec or just parse a .csv file within your application, create your sql commands dynamically for each csv line and execute them with JDBC execute().

answered Sep 13, 2011 at 10:31

Kris

5,7923 gold badges29 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lukas Knuth Over a year ago

A prepared statement will be faster when dealing with many inserts.

Kris Over a year ago

yes, it's not the point here, either way you create an sql command dynamically.

Collectives™ on Stack Overflow

Java and programmatically importing a csv into an SQLite3 table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related