I'm automating a data migration task in wich i'm exporting data from a txt file to an excel sheet.
Excel has an object called querytable, wich has an array property called textfilecolumndatatypes; this property stores a value for each column in the source file.
In fact, something like:
Myarray = MyQuerytable.TexFileColumnDataTypes
returns an array, but (here's my problem)
MyQuerytable.TexFileColumnDataTypes = Myarrray
is not a valid statement (syntax error).
So invalid are these other approaches:
MyQuerytable.TexFileColumnDataTypes = Myarrray(1)
MyQuerytable.TexFileColumnDataTypes(1) = '1,1'
MyQuerytable.TexFileColumnDataTypes = '1,1'
...
How do I get to put some values in this property?
TIA
There´s a better life... Just it´s more expensive!
Cristóbal Manrique M.