my dog learned polymorphism*
The moose likes JDBC and the fly likes Upload contents of csv file into database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Upload contents of csv file into database" Watch "Upload contents of csv file into database" New topic
Author

Upload contents of csv file into database

Eduardo Ponce de Leon
Ranch Hand

Joined: May 13, 2009
Posts: 99
Does anybody know of a good tutorial on how to upload a file in a jsp page and when you click on the upload button the .csv file will be processed and insert each column into a table in a database?
Thank you
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19655
    
  18

Check out our AccessingFileFormats FAQ, especially the Excel section. It includes several libraries for reading CSV files. I myself have successfully used opencsv in several projects.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Upload contents of csv file into database
 
Similar Threads
uploading csv file into mysql database using jsp
comparing csv file values with database attributes.
Advice on Checking the data with database
Copy whole table from DB2 to Oracle
SQL LOADER USE