Set excelConn = New Connection
excelConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & openFileName & ";Extended Properties=excel 8.0;Persist Security Info=False"
Set tableRs = excelConn.OpenSchema(adSchemaTables)
Set tmpRs = New Recordset
'Do While Not tableRs.EOF
tmpRs.Open "select * from [" & tableRs("Table_Name") & "]", excelConn, adOpenKeyset
excelConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & openFileName & ";Extended Properties=excel 8.0;Persist Security Info=False"
Set tableRs = excelConn.OpenSchema(adSchemaTables)
Set tmpRs = New Recordset
'Do While Not tableRs.EOF
tmpRs.Open "select * from [" & tableRs("Table_Name") & "]", excelConn, adOpenKeyset
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货