好办。 Dim db As Database Dim rs As Recordset Set db = OpenDatabase(yourExcelPath, True, False, "Excel 5.0") set rs = db.OpenRecordset("select distinct field1 form [" & sSheetName & "$]") Do Until rs.EOF db.Execute "Select * into " & rs!field1 & " from [" & sSheetName & "$] where field1='" & rs!field1 & "'" rs.MoveNext Loop rs.Close Set rs = Nothing db.Close Set db = Nothing
Dim db As Database
Dim rs As Recordset
Set db = OpenDatabase(yourExcelPath, True, False, "Excel 5.0")
set rs = db.OpenRecordset("select distinct field1 form [" & sSheetName & "$]")
Do Until rs.EOF
db.Execute "Select * into " & rs!field1 & " from [" & sSheetName & "$] where field1='" & rs!field1 & "'"
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
db.Close
Set db = Nothing
先把excel导到数据库在操作也可以。