st = "insert into 新表名 select * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=D:\123" & n & ".xls;Extended Properties=EXCEL 8.0')...[Sheet1$] ;"
这段代码不怎么懂,猜一下,不知道对不对?{:912:}
Sub aa()
Dim n
For n = 1 To 3 Step 1
st = "insert into 新表名 select * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=D:\123\" & n & ".xls;Extended Properties=EXCEL 8.0')...[Sheet1$] ;"
Next n
End Sub