Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import from MS-Excel: Column DV missing!?!
Message
From
13/04/2011 02:03:18
Jill Derickson
Software Specialties
Saipan, CNMI
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Import from MS-Excel: Column DV missing!?!
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Miscellaneous
Thread ID:
01507098
Message ID:
01507098
Views:
105
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()?
Next
Reply
Map
View

Click here to load this message in the networking platform