VB如何将Excel中的数据批量导入到Access中?
VB如何将Excel中的数据批量导入到Access中?
日期:2018-03-01 23:07:45 人气:1
Option Explicit
Dim data As New ADODB.Connection
Dim db As New ADODB.Recordset
Dim xlsApp As Excel.Application
Dim xlsBook As Excel.Workbook
Dim xlsSheet As Excel.Worksheet
Private Sub Command1_Click()
On Error GoTo ErrHandler
CommonDialog1.DialogTitle