Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import from MS-Excel: Column DV missing!?!
Message
 
 
À
14/04/2011 14:33:30
Jill Derickson
Software Specialties
Saipan, CNMI
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Divers
Thread ID:
01507098
Message ID:
01507380
Vues:
37
>>>>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.

Before saving the file in earlier version make sure to unhide all columns. In the routine I sent you there is a code that does that.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform