This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to retrieve data from excel

 
Karthikeyan Ravindran
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 120
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Karthikeyan Ravindran
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 86
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
>String insert1 = "insert into [Difference$] (CardNo,Exit,Entry) values(?,?,?)";
> ps = conn.prepareStatement(insert1);
It shouldn't be in the while loop.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic