7,763
社区成员
发帖
与我相关
我的任务
分享
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\f1.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
cn.Execute "Insert Into [;database=" & App.Path & "\f2.mdb].[user](姓名,年龄,部门,电话) Select 姓名,年龄,部门,电话 From [Sheet1$]"
cn.Close
Set cn = Nothing