试试看 Private Sub TxtToMdb(sTxtPath As String, sTxtFileName As String, sAccessFullFileName As String,sAccessTable As String) '功能:将文本文件导入到Access中的表 '调用:Call TxtToMdb("c:\","test.txt","c:\a.mdb","NewTempTable") '结果:将c:\test.txt导入到c:\a.mdb中的NewTempTable表中 Dim db As DAO.Database
Set db = DBEngine.CreateDatabase(sAccessFullFileName, dbLangGeneral) If Err.Number = 3204 Then Set db = Workspaces(0).OpenDatabase(sAccessFullFileName) End If db.Execute "SELECT * into " & sAccessTable & " FROM [Text;HDR=NO;DATABASE=" & sTxtPath & "]." & sTxtFileName db.Close Set db = Nothing End Sub
Private Sub TxtToMdb(sTxtPath As String, sTxtFileName As String, sAccessFullFileName As String,sAccessTable As String)
'功能:将文本文件导入到Access中的表
'调用:Call TxtToMdb("c:\","test.txt","c:\a.mdb","NewTempTable")
'结果:将c:\test.txt导入到c:\a.mdb中的NewTempTable表中 Dim db As DAO.Database
Set db = DBEngine.CreateDatabase(sAccessFullFileName, dbLangGeneral)
If Err.Number = 3204 Then
Set db = Workspaces(0).OpenDatabase(sAccessFullFileName)
End If
db.Execute "SELECT * into " & sAccessTable & " FROM [Text;HDR=NO;DATABASE=" & sTxtPath & "]." & sTxtFileName
db.Close
Set db = Nothing
End Sub
http://expert.csdn.net/Expert/topic/2202/2202104.xml?temp=7.365054E-02
http://www.sijiqing.com/vbgood/experience/index.asp?action=read&id=2310
http://www.sijiqing.com/vbgood/article/001311546.html
http://vbboshi.myrice.com/vbtech/database/page_4/file111.htm
http://www.china-askpro.com/msg9/qa42.shtml