Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import from MS-Excel: Column DV missing!?!
Message
 
 
To
13/04/2011 19:53:02
Jill Derickson
Software Specialties
Saipan, CNMI
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Miscellaneous
Thread ID:
01507098
Message ID:
01507251
Views:
54
>>VFP IMPORT command does not work with Excel 2007 and later. See Microsoft Visual FoxPro fails to import Microsoft Excel 2007 Workbook saved in "Excel 97-2003 Workbook" format.
>>Check Using Excel 2007 File Formats in VFP 9.0 and Importing data from a Microsoft Excel 2007 workbook using Visual FoxPro 9.0 for alternatives
>
>Thanks Sergey...I've been importing Excel 2007 for years, by detecting that VFP can't handle it, than saving it to an Excel file of an earlier version...I CAN IMPORT and can deal w/the data, it's just that wiered column naming...in the source Excel file the columns are named ....DU, DV, DW.
>

Let me repeat it again, VFP IMPORT command does not work with Excel 2007 and later files. You're IMPORTing one of previous versions and should have made it clear from the beginning.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform