File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes read data from csv file and store it in database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "read data from csv file and store it in database" Watch "read data from csv file and store it in database" New topic
Author

read data from csv file and store it in database

Ganeshkumar cheekati
Ranch Hand

Joined: Oct 13, 2008
Posts: 362
Can any one send me the code to read CSV file and save the data in database .....? its so urgent please help me...
thanks in advance?


SCJP5 and SCWCD1.5
Think Twice Act Wise...
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42950
    
  70
What do you have so far? There are any number of libraries that can read CSV. Storing it in the DB most likely involves the JDBC API; are you familiar with that? There are also ETL tools for bulk loading of data into DBs (it's even possible that one comes with whatever DB you're using). So ... TellTheDetails.
Jalli Venkat
Greenhorn

Joined: Aug 10, 2006
Posts: 27
HI Ulf,
I am also have same requirement as Ganeshkumar .

My requirement is : I have a CSV file data with multiple columns and rows.
I want to insert that data into the Database(Oracle) table.
Can you please guide me the approach or provide me the code if available.

Thanks in advance.


venkat
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42950
    
  70
Looks like that's pretty much the same question ... so my answer is also the same :-)
mahesh shinde
Ranch Hand

Joined: Jul 24, 2009
Posts: 69

Hi Ganeshkukar
Some database support bulk load means you can provide them CVS or excel file and some database routines read the data and load it in tables .
So Ulf is asking you what you know /in which way you want implement data load using DB or Java.
yes it's also possible to load data using JAVA
Discuss what you want and what you know
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: read data from csv file and store it in database