Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eric de Haan
  Where is Eric de Haan?
 Alkmaar
 Netherlands
 Eric de Haan
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: append from excel does not import
Thread ID: 269059 Message ID: 269076 # Views: 28 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Friday, July 16, 2010 10:32:02 AM         
   


> > Hi everyone,
> >
> > I am stuck with a "problem". For a client I was asked to create a function to import a contract, which they have created in Excel, into their database. So I created a cursor existing of n-columns (c(230)) and did an append from type xls. That works, only I didn't get all rows from the worksheet as a record in the cursor. Some blank rows were in the cursor and some didn't. For some rows it doesn't matter because they contain no information. But other rows are separators between chunks of data and they are glued together in my cursor.
> >
> > Can someone please tell me why blank rows not always result in a blank record?
> >
> > kind regards,
> > Eric
>
> Are they really separate rows in Excel, or are they simply a row with extra height?
>
> -Anders

Hi Anders,

They are really seperate rows. (Excel shows rownumber) And the reccount() of my cursor is less than the last filled row in excel.

Eric

ENTIRE THREAD

append from excel does not import Posted by Eric de Haan @ 7/16/2010 9:40:21 AM
RE: append from excel does not import Posted by Anders Altberg @ 7/16/2010 9:56:03 AM
RE: append from excel does not import Posted by Eric de Haan @ 7/16/2010 10:32:02 AM