'工程->引用->Microsoft ActiveX Data Objects 2.x Library
'Access导出到Txt
Option Explicit
Public mCnnString As String
Private Sub Command1_Click()
Dim mCnn As New ADODB.Connection
mCnn.Open mCnnString
mCnn.CursorLocation = adUseClient
mCnn.Execute "Select * Into [Text;DATABASE=" & App.Path & "\].[db1.Txt] From [YourTable]" 'db1.Txt是程序执行后生成,YourTable是db1.mdb其中的一个表
Kill App.Path & "\Schema.ini" '删除临时文件
End Sub
Private Sub Form_Load()
mCnnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb" & ";Persist Security Info=False"
End Sub
'請你自己加個CommonDialog控件
Private Sub Command3_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