We are having problems using the queryTables command with the .TextFileColumnDataTypes method.

We are importing a 3 field text file into a 3 column excel object. The 2nd column contains all numeric data but the field is a character - we want to show leading 0's. Excel macro shows using the QueryTables command with the following syntax for the .TextFileColumnDataTypes method:

.TextFileColumnDataTypes = Array(1, 2, 1)

VFP does not like the word "Array" so we tried creating a public single column VFP array with 1,2,1 as the values.

We tried formatting the column to a text file before importing the text file, formatting the column after inserting the data. We could make the 2nd column a 4 character field with a single quote being the first character but we didn't think we would have to do this.

Any suggestions of ideas would be greatly appreciated!!

Thank you in advance for your help.

Sincerely,

Joyce Herr