Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import from MS-Excel: Column DV missing!?!
Message
De
13/04/2011 19:55:57
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:
01507207
Vues:
37
>>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()?
>
>Hi Jill,
>
>Is DV column present in the file (not hidden)? I do have code that imports from Excel using Ole Automation, I have it published here a couple of times. Let me know if you will need help finding the thread.

Yes. Thanks Naomi.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform