34,590
社区成员
发帖
与我相关
我的任务
分享
Private Sub Command3_Click()‘将excel数据导入EXCEL
Dim strexSQL As String
strexSQL = "Insert into paravalue([姓名],[年龄],[班级],[数学成绩]) select [姓名],[年龄],[班级],[数学成绩] from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 8.0;HDR=YES;DATABASE=" & App.Path & "\testing.xls',sheet1$)"
DBcnn.Execute (strexSQL)
End Sub
Private Sub Command4_Click() ‘将SQL数据导出EXCEL
Dim strexSQL As String
strexSQL = "Insert Into OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=" & App.Path & "\testing.xls;','SELECT [姓名],[年龄],[班级],[数学成绩] FROM [Sheet1$]') select [姓名],[年龄],[班级],[数学成绩] from paravalue"
DBcnn.Execute strexSQL
End Sub