我以前使用下面的代码没有问题的
Dim db As dao.Database
Set db = OpenDatabase(sExcelPath, True, False, "Excel 5.0")
db.Execute ("Insert into [;database=" & sAccessDBPath & "]." & _
sAccessTable & " select * FROM [" & sSheetName & "$] " & sCon)但现在access数据库加密码了,打开时会报密码错误,如何把密码作为参数传进去?
Dim db As dao.Database
Set db = OpenDatabase(sExcelPath, True, False, "Excel 5.0")
db.Execute ("Insert into [;database=" & sAccessDBPath & "]." & _
sAccessTable & " select * FROM [" & sSheetName & "$] " & sCon)但现在access数据库加密码了,打开时会报密码错误,如何把密码作为参数传进去?
db.Execute ("Insert into " & sAccessTable & _
" Select * FROM [" & sSheetName & "$] In """ & _
sExcelPath & """ ""Excel 5.0""" & sCon)
db.Execute ("Insert into " & sAccessTable & _
" Select * FROM [" & sSheetName & "$] In """ & _
sExcelPath & """ ""Excel 5.0""" & sCon)
Insert into pool Select * FROM [pool$] In "F:\sam\FRDMb.xls" "Excel 5.0"报错:不可识别的数据库格式 'F:\sam\备份\trace\trace\Trace(CHN)\Developer\mb\FRDMB.xls'。