DIM STR() STR=split(aa,vbKeyReturn) STR(0)里为 AAA STR(1)里为 BBB STR(2)里为 CCC
Dim strArray() As String rs.Open "select replace(aa,'111','') as aa from 表1", cn Open "d:\test.txt" For Output As #1 Do While Not rs.EOF strArray = Split(rs!aa, vbCrLf) Print #1, strArray(0) Erase strArray rs.MoveNext Loop Close #1
可能要改一下,(没有验证) Dim strArray() As String dim i as integer rs.Open "select replace(aa,'111','') as aa from 表1", cn Open "d:\test.txt" For Output As #1 Do While Not rs.EOF strArray = Split(rs!aa, vbCrLf) for i=0 to ubound(strarray) Print #1, strArray(i) next i Erase strArray rs.MoveNext Loop Close #1
如果你确定他们之间是回车分隔
STR=split(aa,vbKeyReturn)
STR(0)里为 AAA
STR(1)里为 BBB
STR(2)里为 CCC
rs.Open "select replace(aa,'111','') as aa from 表1", cn
Open "d:\test.txt" For Output As #1
Do While Not rs.EOF
strArray = Split(rs!aa, vbCrLf)
Print #1, strArray(0)
Erase strArray
rs.MoveNext
Loop
Close #1
Dim strArray() As String
dim i as integer
rs.Open "select replace(aa,'111','') as aa from 表1", cn
Open "d:\test.txt" For Output As #1
Do While Not rs.EOF
strArray = Split(rs!aa, vbCrLf)
for i=0 to ubound(strarray)
Print #1, strArray(i)
next i
Erase strArray
rs.MoveNext
Loop
Close #1