File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
Similar Threads
Best way to load data file into an array
reducing load on server
Need technical guidance to solve my issue
loading data from excel to oracle/informix
Excel File opening