幸得一代码,是关于导入Excel的,但有一细节,小弟不知该如何改!
Private Sub cmdInput_Click()
ExportExcelSheetToAccess "Sheet1", "C:\Test.xls", "Emptable", "C:\dbemp.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 8.0")
Call db.Execute("Select * into [;database=" & sAccessDBPath & "]." & sAccessTable & " from [" & sSheetName & "$]")
MsgBox "导入成功!", vbInformation, "提示"
ReShow
End Sub
现在点击“cmdInput”按钮就可以把"C:\Test.xls"中"Sheet1"表内的数据导入到"C:\dbemp.mdb"的"Emptable"表内,但问题是,如果“dbemp.mdb”中已经存在"Emptable"表,那么导入将出错,就算"Emptable"表只有结构没有数据也一样出错,也就是说,只能导入一次,第二次导入的时候,因为第一次已经生成"Emptable"表了,所有第二次导的时候会出错。
请教大哥们该如何解决呢?最好是"Emptable"表就算存在,也不会出错,呵呵