>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.
J
>
>>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()?