Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP8 importing from Excel
Message
De
28/01/2009 19:10:16
 
 
À
28/01/2009 13:07:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01377715
Message ID:
01377938
Vues:
26
>For Excel 2003 format, use TYPE XL8. For Excel 2007 format, you can't use IMPORT. Unfortunately, Excel 2007 is broken, so that even when you save in the earlier format, you can't IMPORT/APPEND those files.
>

Tamar -- this is a good example of how we can keep going with VFP even when the world changes around us. SInce VFP can't import Excel 2007 (and probably beyond) files, we can lean back on Excel's backward compatibility features and do a kludgey but totally workable endrun around it. One day Excel automation will probably break with VFP, and that's when someone will probably come up with another workaround using some other kludge.

I've used the save-first-to-previous-version-then-import-to-VFP -approach for quite a while -- actually ever since Office 2007 came out -- and it really does work quite well.

Lesson learned: It takes a LOT to beat a maverick group like VFP developers into (.NET) submission, and at some point MS might as well stop trying :-)
Pertti Karjalainen
Product Manager
Northern Lights Software
Fairfax, CA USA
www.northernlightssoftware.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform