Public Sub MdbToxls(sAccessFileName As String, sExcelPath As String, sSheetName As String, sAccessTable As String)
Dim db As DAO.Database
Set db = Workspaces(0).OpenDatabase(sAccessFileName)
db.Execute "SELECT * INTO [Excel 8.0;DATABASE=" & sExcelPath & "].[" & sSheetName & "] FROM [" & sAccessTable & "]"
db.Close
Set db = Nothing
End Sub
我想再dim一个int,把select count(*() from table 的值赋给它,应该怎么加在这个代码中,请给我写好的代码,而不只是提示,谢谢
Dim db As DAO.Database
Set db = Workspaces(0).OpenDatabase(sAccessFileName)
db.Execute "SELECT * INTO [Excel 8.0;DATABASE=" & sExcelPath & "].[" & sSheetName & "] FROM [" & sAccessTable & "]"
db.Close
Set db = Nothing
End Sub
我想再dim一个int,把select count(*() from table 的值赋给它,应该怎么加在这个代码中,请给我写好的代码,而不只是提示,谢谢
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = Workspaces(0).OpenDatabase(sAccessFileName)
db.Execute "SELECT * INTO [Excel 8.0;DATABASE=" & sExcelPath & "].[" & sSheetName & "] FROM [" & sAccessTable & "]"
rs.OpenRecordset "Select Count(ID) AS IDCount FROM [" & sAccessTable & "]"
MdbToxls = rs.Fields("IDCount").Value
rs.Close
Set rs = Nothing
db.Close
Set db = Nothing
End Function
Dim db As DAO.Database
Dim rs As DAO.Recordset Set db = Workspaces(0).OpenDatabase(sAccessFileName)
db.Execute "SELECT * INTO [Excel 8.0;DATABASE=" & sExcelPath & "].[" & sSheetName & "] FROM [" & sAccessTable & "]"
rs.OpenRecordset "Select Count(ID) AS IDCount FROM [" & sAccessTable & "]"
MdbToxls = rs.Fields("IDCount").Value
rs.Close
Set rs = Nothing db.Close
Set db = Nothing
End Function
dim a as Integer
a=MdbToxls(.......)
怎么解决?