Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XLSX saved as XLS not importable
Message
 
 
To
21/12/2006 10:16:51
General information
Forum:
Visual FoxPro
Category:
Third party products
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01179563
Message ID:
01179568
Views:
16
The XL8 is Excel 97 format. That's what user should select in Save AS dialog. VFP IMPORT/APPEND FROM commands will not recognize any later XLS formats.

>When we save an XLSX as XLS in Office 2007, the resulting XLS cannot be imported in Foxpro using "Import from .... " type XLS (or XL5 or XL8)
>Foxpro says : "Microsoft Excel file format is invalid"
>
>Anybody any idea what's going on?
>Our customers have to import on a very regular basis large xls sheets into our application.
>So first we import them so they can map the Xls fields to the destination Dbf fields in our application
>
>Xlsx in not feasable, the resulting XML's do not contain the columnnames and the domparser is way too slow to import lage xml's in Foxpro.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform