Private Sub Command1_Click() Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim strTemp As String Dim i As Integer cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Persist Security Info=False" rs.Open "select * from table1", cn, 1, 1
Open "c:\11.txt" For Output As #1
While Not rs.EOF For i = 0 To rs.Fields.Count - 1 strTemp = strTemp & rs(i) & " " Next Write #1, strTemp strTemp = "" rs.MoveNext Wend Close #1 Set rs = Nothing cn.Close Set cn = Nothing End Sub
Open Trim(cdtxt2.FileName) For Output As #1
For i = 0 To rssql1.Fields.Count - 1 strTemp = strTemp & rssql1.Fields(i).Name & " " Write #1, strTemp strTemp = "" Next使用如上语句向文本文件写入字段名时,有多少字段名,便在文本中写了多少行,如何把字段名写在一行里面
Do While Not Rs.Eof
Print #1, rs.fileds(0) & vbCr
rs.movenext
Next Index
Close #1
Do While Not Rs.Eof
Print #1, rs.fileds(0) & vbCr
rs.movenext
Loop '这边写错
Close #1
Rs.Save strFile, adPersistXML
自己去看一看帮助了,如果导回也非常方便(XML格式当然方便了)
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strTemp As String
Dim i As Integer
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Persist Security Info=False"
rs.Open "select * from table1", cn, 1, 1
Open "c:\11.txt" For Output As #1
While Not rs.EOF For i = 0 To rs.Fields.Count - 1
strTemp = strTemp & rs(i) & " "
Next
Write #1, strTemp
strTemp = ""
rs.MoveNext
Wend
Close #1 Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub
For i = 0 To rssql1.Fields.Count - 1
strTemp = strTemp & rssql1.Fields(i).Name & " "
Write #1, strTemp
strTemp = ""
Next使用如上语句向文本文件写入字段名时,有多少字段名,便在文本中写了多少行,如何把字段名写在一行里面