This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes read data from excel sheet and put it into the postgresql 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 "read data from excel sheet and put it into the postgresql database" Watch "read data from excel sheet and put it into the postgresql database" New topic
Author

read data from excel sheet and put it into the postgresql database

Ron Isac
Greenhorn

Joined: Dec 22, 2004
Posts: 9
Hi,
I want to read the data from an excel sheet and put that data into the postgresql database. There is tables in the database similar to the excel sheet. How can I do that ? Please help me.
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Ron,
In my opinion, your question has nothing to do with servlets, it has to do with JDBC.

There are JDBC drivers that allow you to read data from Excel spreadsheets.
Just do an Internet search for the terms "excel" and "JDBC".

Alternatively, you may be able to use the POI project to read the Excel data.

Once you have read the data (from Excel), you can use JDBC (again) to insert the data into your PostgreSQL database.
[Of-course, you will need to obtain the relevant JDBC driver for PostgreSQL. This is not the same driver as required for Excel.]

Good Luck,
Avi.
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

Moving this to the JDBC forum.

Avi is correct, this isn't a Servlets question. This forum is for Servlets questions.

Thanks

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: read data from excel sheet and put it into the postgresql database
 
Similar Threads
handling excel sheet with java
How to read Excel in Java application
Generate Excel file
Reading XLS file
Oracle 9i to Excel Sheet