aspose file tools*
The moose likes JDBC and the fly likes How to retrieve data from excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to retrieve data from excel" Watch "How to retrieve data from excel" New topic
Author

How to retrieve data from excel

Karthikeyan Ravindran
Ranch Hand

Joined: Nov 20, 2007
Posts: 32
Hi All

Please help me to retreive data from two different table of excel sheet.


This is the code which is giving the unexcepted result. And please see the two different table name and the field name too.

Table Name1: Exit
Field Name: Time & CardNo

Table Name2:Entry
Field NAme:Time & CardNo

But the result which I want to see is that:

CardNo,Exit and Entry field should has to come in a new Table.Please take some time values with same card for entry and exit time.

[ June 20, 2008: Message edited by: Paul Sturrock ]
Rakesh Chaudhary
Ranch Hand

Joined: Feb 19, 2008
Posts: 120
Hi specify and describe the whole error,,I recently worked with the excel sheets and trust me it gave me the worst night meirs.....but at the end I was able to solve...it


Acquire the unexpected.......
Preparing for SCJP 6
Karthikeyan Ravindran
Ranch Hand

Joined: Nov 20, 2007
Posts: 32
Hi

Thanks for your valuable reply and could you please tell me the query to retrieve the data from two different excel sheets with the comparision of one same value.

Please see the below table and tell me the query

CardNo Time these two field for Sheet1.
CardNo Time these two field for Sheet2.

I have to take the time from each table when the card numbers are same in the two sheets.
Wei Dai
Ranch Hand

Joined: Jun 22, 2005
Posts: 86
>String insert1 = "insert into [Difference$] (CardNo,Exit,Entry) values(?,?,?)";
> ps = conn.prepareStatement(insert1);
It shouldn't be in the while loop.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to retrieve data from excel