Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Import from MS-Excel: Column DV missing!?!
Versions des environnements
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()?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement