程序如下
Private Sub Command3_Click()
ExportExcelSheetToAccess "1", "C:\temp\1.csv", "TestTable", "C:\temp\1.mdb"
End Sub
Private Sub ExportExcelSheetToAccess(sSheetName As String, _
sExcelPath As String, sAccessTable As String, sAccessDBPath As String)
Dim db As Database
Dim rs As Recordset
Set db = OpenDatabase(sExcelPath , True, False, "Excel 5.0")
Call db.Execute("Select * into [;database=" & sAccessDBPath & "]." & _
sAccessTable & " FROM [" & sSheetName & "$]")
MsgBox "Table exported successfully.", vbInformation, "Yams"
End Sub
OpenDatabase中最后一个参数"Excel 5.0"只能对Excel文件操作。如果是CSV文件的话
就会报错。如果是CSV文件这个参数应该是什么?
Private Sub Command3_Click()
ExportExcelSheetToAccess "1", "C:\temp\1.csv", "TestTable", "C:\temp\1.mdb"
End Sub
Private Sub ExportExcelSheetToAccess(sSheetName As String, _
sExcelPath As String, sAccessTable As String, sAccessDBPath As String)
Dim db As Database
Dim rs As Recordset
Set db = OpenDatabase(sExcelPath , True, False, "Excel 5.0")
Call db.Execute("Select * into [;database=" & sAccessDBPath & "]." & _
sAccessTable & " FROM [" & sSheetName & "$]")
MsgBox "Table exported successfully.", vbInformation, "Yams"
End Sub
OpenDatabase中最后一个参数"Excel 5.0"只能对Excel文件操作。如果是CSV文件的话
就会报错。如果是CSV文件这个参数应该是什么?
解决方案 »
- 用VB怎样控制Epson打印机的退纸?
- vb取消保存的问题
- 如何在一个datareport上按顺序打印多个adodc数据集?
- 采集进来一组声音信号,如何通过VB对其做个频谱分析啊?
- 我想做一个控件,希望有adodc一样的属性页,不知道能否直接调用adodc的属性页,请高手指教!
- 急救,马上给分,我想在picture控件保留原有的图象,但还要画上新的图象,怎么办啊??
- 用vb引用excel的数据中的内容后,当把vb运行结束后,发现excel仍然在后台运行,只是我门没看到,运行几次就开几个,如
- 关于Microsoft ActiveX Data Objects 2.0 library控件的问题?
- 我用mapi控件发邮件,顺序如下,虽然发送成功了,但是同时将邮件放入了我的收件箱里,我不想收件箱产生邮件,该如何做?
- VB怎么制作浮动的面板?
- 请教诸位
- Crystal 8.如何显示的行数固定
Dim oBook As Object
Dim oSheet As Object
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Open("d:\1.csv")
'Save as Excel workbook and Quit Excel
oBook.SaveAs "d:\1.xls", xlWorkbookNormal
oExcel.Quit 以上代码不知能否帮到你!
Set dbOpenFile = DBEngine.Workspaces(0).OpenDatabase(txtFile.Text, False, False, "Excel 8.0;")mdb:
Set dbOpenFile = DBEngine.Workspaces(0).OpenDatabase(txtFile.Text, False, False, "")dbase\foxpro:
Set dbOpenFile = DBEngine.Workspaces(0).OpenDatabase(GetPathName(txtFile.Text), False, False, "dBASE 5.0;")txt:
Set dbOpenFile = DBEngine.Workspaces(0).OpenDatabase(GetPathName(txtFile.Text), False, False, "Text;")
ExportExcelSheetToAccess "1", "C:\temp\1.csv", "TestTable", "C:\temp\1.mdb"
中"c:\temp\1.csv"改成"c:\temp\"
改成:
Set db = OpenDatabase(sExcelPath , True, False, "Text;")
Set db = DBEngine.CreateDatabase("c:\a.mdb", dbLangGeneral)
If Err.Number = 3204 Then
Set db = Workspaces(0).OpenDatabase("c:\a.mdb")
End If db.Execute "SELECT * into NewTempTable FROM [Text;HDR=NO;DATABASE=C:\].test.txt"
db.Close
Set db = Nothing