Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append from filename type xl5 crashes VFP
Message
De
22/06/2000 11:48:11
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00383176
Message ID:
00383208
Vues:
17
>A co-worker was beginning to develop an app to import data from an Excel file and then do whatever manipulations were needed. He created a dbf by saving the files as dbase III format and then zapped the file (so was blank). Went into VFP and used the table he had just created. Issued the command: APPEND FROM filename.xls TYPE XL5 (also try TYPE XLS). VFP seemed to think for a moment and then just disappeard/shut down without notice. I decided to try this on my computer to see what the results were...exactly the same thing happened.
>
>Has anyone had this happen to them? Is this a known bug that I missed?
>
>Thanks,
>George


George,
Is .xls file in Excel5.0 format ? That's the only version AFAIK that doesn't have bugs with 'append from'. Also VFP6 SP3 has corrected some of the bugs.
'import from' might be a solution. Another one is to save as CSV, delimited or dBaseIII format from Excel.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform