Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP8 importing from Excel
Message
From
28/01/2009 19:10:16
 
 
To
28/01/2009 13:07:39
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01377715
Message ID:
01377938
Views:
31
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform