Osmar Morais
New Member
I´m trying to import data from text files to Excel and I need to define some columns as "text" others as "date", and son on, but, for one of the parameters (the 11º, FiledInfo) I´m not managing to adjust the syntax for OpenEdge COM Object.
I listed below the command generated for Excel macro:
Workbooks.OpenText Filename:="C:\TEMP\es1203a090810-042150.sdf", Origin:= _
xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote _
, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=True, Comma:= _
False, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 2), Array(2, 2) _
, Array(3, 1), Array(4, 1), Array(5, 2), Array(6, 1), Array(7, 2), Array(8, 4), Array(9, 2), _
Array(10, 1), Array(11, 1), Array(12, 1), Array(13, 4), Array(14, 2), Array(15, 1), Array( _
16, 1), Array(17, 1), Array(18, 1), Array(19, 1), Array(20, 1)), TrailingMinusNumbers _
:=True
I tryed:
ASSIGN chWB2 = chXL:Workbooks:OPENTEXT(cFile1,,1,1,2,False,False,True,False,False,False,iFormat,True).
Where "iFormat" is a extent integer variable with the related field type, I used this variable because I don´t know hou to write this information (Array(1,2), Array(2,2), and so on) in OpenEdge COM Sintaxe, I also tryed to use a temp-table and to to enclose in quotas, without success.
If someone had faced this problem and could help me I thank.
I listed below the command generated for Excel macro:
Workbooks.OpenText Filename:="C:\TEMP\es1203a090810-042150.sdf", Origin:= _
xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote _
, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=True, Comma:= _
False, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 2), Array(2, 2) _
, Array(3, 1), Array(4, 1), Array(5, 2), Array(6, 1), Array(7, 2), Array(8, 4), Array(9, 2), _
Array(10, 1), Array(11, 1), Array(12, 1), Array(13, 4), Array(14, 2), Array(15, 1), Array( _
16, 1), Array(17, 1), Array(18, 1), Array(19, 1), Array(20, 1)), TrailingMinusNumbers _
:=True
I tryed:
ASSIGN chWB2 = chXL:Workbooks:OPENTEXT(cFile1,,1,1,2,False,False,True,False,False,False,iFormat,True).
Where "iFormat" is a extent integer variable with the related field type, I used this variable because I don´t know hou to write this information (Array(1,2), Array(2,2), and so on) in OpenEdge COM Sintaxe, I also tryed to use a temp-table and to to enclose in quotas, without success.
If someone had faced this problem and could help me I thank.