Soren,
to add to the above,
1. create a PreparedStatement to use as your INSERT statement (reusable)
2. loop through each line in the textfile
3. for each line, use the String.split( "," ) method to split your input line into columns
4. assign each
String[] value to a prepared statement ? using the PreparedStatement.setString( 1, String[0] ) method
5. add the statement to batch ( PreparedStatement.addBatch()
6. after all the records are added to batch, use the PreparedStatement.executeBatch() method to execute all the inserts at one time.
7. commit the inserts
You'll find that by batching the inserts, you'll noticeable speed up your bulk insert.
Jamie