This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes I/O and Streams and the fly likes lading data from file into database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Java » I/O and Streams
Bookmark "lading data from file into database" Watch "lading data from file into database" New topic

lading data from file into database

Muhammad Qureshi

Joined: Mar 05, 2002
Posts: 9
Hi all,
I have to load data from xls file to database, I have saved file as csv and had used stringtokenizer to parse it, now how can i load this data in to database.
Juanjo Bazan
Ranch Hand

Joined: Feb 04, 2002
Posts: 231
You have to create/open a connection to your database using the suitable JDBC driver, and insert the data into the tables using SQL.
I agree. Here's the link:
subject: lading data from file into database
jQuery in Action, 3rd edition