Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import from MS-Excel: Column DV missing!?!
Message
From
14/04/2011 14:33:30
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:
01507375
Views:
41
>>>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 weired 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.

Sorry, i thought it was clear, in that the file WAS imported w/out an error from VFP.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform