When importing a txt file into excel, I need to specify data types for the columns.
I'm currently using Excel 2003 (upgrade to 2010 is for later in the summer).
I have been able to find enumerations of the possible values for xlColumnDataType for version 2007 and 2010 of Excel VBA, but not for Excel 2003.
Are the possible values the same in Excel 2003 as in the later versions?
The usage of xlColumnData type is as such when importing a 3 column txt file.
Workbooks.OpenText FileName:= "the file name to be imported.txt", _ <various other arguments>,_
FieldInfo:=Array(Array(1, 2), Array(2, 2), Array(3, 1)),
I need to know the possible values of the second numeric value in each Array argument and what data types they correspond to.
UPDATE: For reference sake here is the list of xlColumnDataType sorted by the value number:
xlGeneralFormat 1 xlTextFormat 2 xlMDYFormat 3 xlDMYFormat 4 xlMDFFormat 5 xlMYDFormat 6 xlDYMFormat 7 xlYDMFormat 8 xlSkipColumn 9 xlEMDFormat 10