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
 Tags
Subject: append from excel does not import
Thread ID: 269059 Message ID: 269059 # Views: 36 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Friday, July 16, 2010 9:40:21 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

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