Falkner 发表于:2019-08-26 16:43:30
'将同目录下excel工作薄中多个表导入access中,生成不同access表
Private Sub Command1_Click()
On Error Resume Next
Dim exapp As New Excel.Application
Dim exBook As Excel.Workbook
Dim exSheet As Excel.Worksheet
Dim strName As String
Set exBook = exapp.Workbooks.Open(CurrentProject.Path & "\SDR_fdd_radio.xlsx")
For i = 1 To exBook.Sheets.Count
DoCmd.TransferSpreadsheet acImport, , exBook.Worksheets(i).Name, CurrentProject.Path & _
"\SDR_fdd_radio.xlsx", True, exBook.Worksheets(i).Name & "!"
Next
exBook.Close
Set exBook = Nothing
exapp.Quit
End Sub
把excel中的数据导入到access数据中,看是不是一个解决方案。excel数据量过大时,不仅打开慢,而且会崩溃。
指令就是把EXCEL所有表导入到access数据库中 ,但有个过程需要你将excel文档打开才能继续,请问有没有不开大文档的方法
总记录:2篇 页次:1/1 9 1 :