参考SQL导出记事本(改为DBF文件的话,你只需要改一下连接字符串和查询字符串就行了):'引用ADO(Microsoft ActiveX Data Objects 2.X Library)Private Sub Command1_Click() Dim cn As New ADODB.Connection, rs As New ADODB.Recordset cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=登陆用户名;Password=登录密码;Initial Catalog=数据库名;Data Source=服务器别名" cn.Open rs.CursorLocation = adUseClient '设置客户端游标 rs.Open "select * from 表1", cn, 3, 2 If rs.EOF Then Exit Sub
Dim i%, strTemp As String For i = 0 To rs.Fields.Count - 1 strTemp = strTemp & rs(i) & "," Next Open "c:\AA.TXT" For Output As #1 Write #1, strTemp Close #1 rs.Close cn.Close Set rs = Nothing Set cn = Nothing End Sub
Private Sub Command1_Click() Dim cn As New ADODB.Connection, rs As New ADODB.Recordset cn.Open "Driver={Microsoft dBASE Driver (*.dbf)}; DriverID=277;Dbq=D:\DatabasePath"
rs.CursorLocation = adUseClient '设置客户端游标 rs.Open "select top 1 * from XXX.dbf", cn, adOpenDynamic, adLockReadOnly If rs.EOF Then Exit Sub
Dim i%, strTemp As String
For i = 0 To rs.Fields.Count - 1 strTemp = strTemp & rs(i) & "," Next
Open "c:\AA.TXT" For Output As #1 Write #1, strTemp Close #1
rs.Close cn.Close Set rs = Nothing Set cn = Nothing End Sub
//讲Text1中的内容写入c:\AA.TXT中
Open"c:\AA.TXT" For Output As #1
Print #1,Text1.Text
Close #1
免费的学习、交流、源码、工具下载网站,欢迎大家访问!
http://www.j2soft.cn/
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=登陆用户名;Password=登录密码;Initial Catalog=数据库名;Data Source=服务器别名" cn.Open
rs.CursorLocation = adUseClient '设置客户端游标 rs.Open "select * from 表1", cn, 3, 2
If rs.EOF Then Exit Sub
Dim i%, strTemp As String
For i = 0 To rs.Fields.Count - 1
strTemp = strTemp & rs(i) & ","
Next
Open "c:\AA.TXT" For Output As #1
Write #1, strTemp
Close #1
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
End Sub
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
cn.Open "Driver={Microsoft dBASE Driver (*.dbf)}; DriverID=277;Dbq=D:\DatabasePath"
rs.CursorLocation = adUseClient '设置客户端游标 rs.Open "select top 1 * from XXX.dbf", cn, adOpenDynamic, adLockReadOnly
If rs.EOF Then Exit Sub
Dim i%, strTemp As String
For i = 0 To rs.Fields.Count - 1
strTemp = strTemp & rs(i) & ","
Next
Open "c:\AA.TXT" For Output As #1
Write #1, strTemp
Close #1
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
End Sub