Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Appending From Excel 2000 Workbook
Message
De
19/07/2001 08:24:14
 
 
À
19/07/2001 07:29:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00532439
Message ID:
00532453
Vues:
10
Marc,
Not sure if this KB Q217174 describes your problem. Probably there's something else, since you get the same problem with TYPE XL5.
I've had problems appending Excel data on some occasions. But in my cases I got a "Error reading file" error and VFP didn't crash. I was never able to nail the problem down, but I think it was related to some special characters in the Excel file. I used automation as a work around.

>I need to append from Excel 2000 Workbook into a table.
>
>When I try append from filename.xls xls Visual FoxPro just crashes out. I have also tried append from filename.xls xl5 and append from filename.xl8 with the same result.
>
>I cannot save it as a worksheet as the Excel file is more then 16000 records and I lose data saving it as an Excel worksheet.
>
>It works when there are only 230 rows in the Excel file but 250 plus and Visual FoxPro just crashes out.
>
>I know I can save it as a tab delimited file if necessary and append it as such but I would prefer to be able to append it straight in from Excel.
>
>Any advice would be appreciated.
Daniel
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform