File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes missing one record from excel to access using datasources for both drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "missing one record from excel to access using datasources for both drivers" Watch "missing one record from excel to access using datasources for both drivers" New topic
Author

missing one record from excel to access using datasources for both drivers

Nalla Praveen
Greenhorn

Joined: Jan 03, 2012
Posts: 2
Good Morning..Iam reading data from .xls Sheet and writing data to access database by craeting datasources for both Excel and access drivers in administrative tools..but my problem is when iam writing to access one less row is coming to access..if i have 5 rows in Excel sheet but only 4 rows are coming to access..but my logic is perfect..iam unable to solve my problem..please any one help me...

thanking you....
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18985
    
    8

Nalla Praveen wrote:but my logic is perfect...


This is not an assumption that a real programmer would make. On the contrary, the chances are that the problem is your fault. And it's probably something simple -- after all your program isn't very complicated at all, is it? Probably something like failing to commit something, or close something.
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19781
    
  20

Paul is right. Most times I encounter a problem, it's because of a small little error I let slip in. Just yesterday I was looking for about 15 minutes why something wasn't working when I noticed I made a simple copy-paste error...


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2516
    
  10

Welcome to the Ranch, Nalla!

Can you post the piece of code that shows us the logic that you used?


OCUP UML fundamental and ITIL foundation
youtube channel
Nalla Praveen
Greenhorn

Joined: Jan 03, 2012
Posts: 2
This is my code...check it and provide me solution

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: missing one record from excel to access using datasources for both drivers