Private Sub Command0_Click()
Open "d:\temp\01.txt" For Output As #1
Dim rs As New adodb.Recordset
rs.Open "联系人", Application.CurrentProject.Connection, adOpenForwardOnly
rs.MoveFirst
Do While Not rs.EOF
Print #1, rs("姓名").Value & rs("地址").Value
rs.MoveNext
Loop
Close #1
Set rs = Nothing
MsgBox "完成"
End Sub 作者: ouxingwang 时间: 2006-6-14 01:00
谢谢指点!作者: wuaza 时间: 2006-6-14 01:02
Open "d:\temp\01.txt" For Output As #1
这句代码新鲜。作者: sccw 时间: 2006-8-3 02:00
经测试可以将数据表输出到文本,但不能将查询表中的数据输出,如果是将查询表的数据输出到文本文件,该用什么函数呢?作者: fan0217 时间: 2006-8-3 02:20
带参数的查询不能直接使用查询名称。将红色的部分该为查询的SQL语句。
Private Sub Command0_Click()
Open "d:\temp\01.txt" For Output As #1
Dim rs As New adodb.Recordset
rs.Open "联系人", Application.CurrentProject.Connection, adOpenForwardOnly
rs.MoveFirst
Do While Not rs.EOF
Print #1, rs("姓名").Value & rs("地址").Value
rs.MoveNext
Loop
Close #1
Set rs = Nothing
MsgBox "完成"
End Sub