Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XLSX saved as XLS not importable
Message
From
21/12/2006 11:14:28
 
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:
01179588
Views:
13
Hi Sergey,

There seems to be only one "Save as" option in office 2007,
"Excell 97 - 2003 workbook"
And that's what we used but to no succes.

Guillaume

>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.
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform