Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import from MS-Excel: Column DV missing!?!
Message
 
 
To
13/04/2011 02:03:18
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:
01507104
Views:
66
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

>Hi, I am using the IMPORT FROM command to read in an Office 2007 MS-Excel file, so field names are A, B, ....Z, AA, AB, ...AZ, BA, BB, etc..
>
>I have to handle files defined as:
> Columns A - M: standard information
> Columns N - R: information about charge 1
> Columns S - W: information about charge 2
> Columns X - AB: information about charge 3
> etc.
>
>In other words, past column M, information is in groups of 5 columns.
>
>NOOOO problem, i thought. I have code that calculates the column name.
>
>BUT lo and behold! what column follows DU??? NO, NOT DV, but DW!
>
>What is going on here? any ideas? this is def. breaking my code.
>
>Any input is appreciated.
>
>Guess i have to change the code to using AFields()?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform