Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and Relational Databases 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 Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
Sheriff

Joined: Oct 14, 2005
Posts: 19691
    
  10

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: 20048
    
  30

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 - OCEJPAD 6
How To Ask Questions How To Answer Questions
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2541
    
  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
Nalla Praveen
Greenhorn

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

 
jQuery in Action, 3rd edition
 
subject: missing one record from excel to access using datasources for both drivers
 
It's not a secret anymore!