楼主请看:(我已测试通过) Option Explicit'在工程"引用"中勾选: 'Microsoft ActiveX Data Objects 2.5 Library
'在工程"部件"中勾选: 'Microsoft ADO Data Control 6.0(SP4) (OLEDB) 'Microsoft Common Dialog Control 6.0 (SP3)'再在窗体上加个CommonDialog控件Private Sub Command1_Click() Dim objFileSystem As Object Dim objExcelText As Object Dim strTableString As String, i As Integer, strFileName As String Dim pubConn As New ADODB.Connection Dim rsTable As New ADODB.Recordset Dim strConn As String Dim strSQL As String
'在工程"部件"中勾选: 'Microsoft ADO Data Control 6.0(SP4) (OLEDB) 'Microsoft Common Dialog Control 6.0 (SP3)'再在窗体上加个CommonDialog控件--------------是不是需要某个文件支持?还是可以直接使用?
Option Explicit'在工程"引用"中勾选:
'Microsoft ActiveX Data Objects 2.5 Library
'在工程"部件"中勾选:
'Microsoft ADO Data Control 6.0(SP4) (OLEDB)
'Microsoft Common Dialog Control 6.0 (SP3)'再在窗体上加个CommonDialog控件Private Sub Command1_Click()
Dim objFileSystem As Object
Dim objExcelText As Object
Dim strTableString As String, i As Integer, strFileName As String
Dim pubConn As New ADODB.Connection
Dim rsTable As New ADODB.Recordset
Dim strConn As String
Dim strSQL As String
'以下取数据的代码,请楼主根据自己的机器设置,如机器名\数据库名等等
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa; password=;Data Source=BTWL;Initial Catalog=Master;"
pubConn.Open strConn
rsTable.CursorLocation = adUseClient
strSQL = "select top 10 * from sysfiles"
rsTable.Open strSQL, pubConn, adOpenDynamic, adLockOptimistic
For i = 0 To rsTable.Fields.Count - 1
'取出字段名
strTableString = strTableString & rsTable.Fields(i).Name & Chr(9)
Next
strTableString = strTableString & rsTable.GetString
cmDialog.CancelError = False
'指定生成的文件名
cmDialog.FileName = "DemoXls"
cmDialog.DialogTitle = "Save Export File"
cmDialog.Filter = "Excel (*.xls)|*.xls|文本文件(*.DBF)|*.DBF|檔案文件(*.doc)|*.doc|所有文件(*.*)|*.*"
cmDialog.DefaultExt = "*.xls"
cmDialog.ShowSave
strFileName = cmDialog.FileName
Set objFileSystem = CreateObject("Scripting.FileSystemObject")
Set objExcelText = objFileSystem.createtextfile(strFileName, True)
objExcelText.writeline (strTableString)
objExcelText.Close
Set objFileSystem = Nothing
End Sub
楼主请看:(我已测试通过)
Option Explicit'在工程"引用"中勾选:
'Microsoft ActiveX Data Objects 2.5 Library
'在工程"部件"中勾选:
'Microsoft ADO Data Control 6.0(SP4) (OLEDB)
'Microsoft Common Dialog Control 6.0 (SP3)'再在窗体上加个CommonDialog控件--------------是不是需要某个文件支持?还是可以直接使用?