aspose file tools*
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
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: 19693
    
  20

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