Excel VBA把Excel导入到Access中

ExcelVBA把Excel导入到Access中ExcelVBA把Excel导入到Access中导入单个EXCEL文件SubExport_Sheet_Data_ToAccess()DimmyFileAsVariantDimAppAccessAsNewAccess.ApplicationDimwbPathAsStringmyFile=Application.GetOpenFilename("ExcelFiles(*.xls),*.xls")IfVarType(myFile)=vbBooleanThen   MsgBox"CanCelbyUser!"   ExitSubEndIfApplication.ScreenUpdating=FalsewbPath=ThisWorkbook.Path&"\"WithAppAccess   .OpenCurrentDatabasewbPath&"CheckIn.mdb",True   .DoCmd.TransferSpreadsheetacImport,acSpreadsheetTypeExcel9,"data",myFile,True   .CloseCurrentDatabaseEndWithApplication.ScreenUpdating=TrueMsgBoxmyFile&Chr(10)&"ExportisDone！"SetAppAccess=NothingEndSub导入多个EXCEL文件SubExport_MultiSheets_Data_ToAccess()DimmyFilesAsVariant,vItemAsVariantDimAppAccessAsNewAccess.ApplicationDimwbPathAsStringmyFiles=Application.GetOpenFilename(_   "ExcelFiles(*.xls),*.xls",,"SelectAllFiles",,True)IfVarType(myFiles)=vbBooleanThen   MsgBox"CanCelbyUser!"   ExitSubEndIfApplication.ScreenUpdating=FalsewbPath=ThisWorkbook.Path&"\"WithAppAccess   .OpenCurrentDatabasewbPath&"CheckIn.mdb",True   IfIsArray(myFiles)Then    ForEachvItemInmyFiles      .DoCmd.TransferSpreadsheetacImport,acSpreadsheetTypeExcel9,"data",vItem,True    Next   EndIf   .CloseCurrentDatabaseEndWithApplication.ScreenUpdating=TrueMsgBox"ExportisDone！"SetAppAccess=NothingEndSub导入一个工作簿下的所有工作表SubExport_Sheets_Data_ToAccess()DimmyFileAsVariantDimAppAccessAsAccess.ApplicationDimwbPathAsStringDimobjWbAsWorkbookDimrngDataAsRangeDimlRowAsLongDimlColAsLongDimarr()AsVariantDimiShtAsIntegerSetAppAccess=NewAccess.ApplicationmyFile=Application.GetOpenFilename("ExcelFiles(*.xls),*.xls")IfVarType(myFile)=vbBooleanThen   MsgBox"CanCelbyUser!"   ExitSubEndIfApplication.ScreenUpdating=FalseSetobjWb=GetObject(myFile)ReDimarr(1ToobjWb.Sheets.Count)ForiSht=1ToobjWb.Sheets.Count   WithobjWb.Sheets(iSht)    lRow=.[a65536].End(xlUp).Row    lCol=.[iv1].End(xlToLeft).Column    SetrngData=.Range(.Cells(1,1),.Cells(lRow,lCol))    arr(iSht)=.Name&"!"&rngData.Address(0,0)   EndWithNextobjWb.CloseFalseSetobjWb=NothingwbPath=ThisWorkbook.Path&"\"WithAppAccess   .OpenCurrentDatabasewbPath&"Database.mdb",True   ForiSht=1ToUBound(arr)    .DoCmd.TransferSpreadsheetacImport,acSpreadsheetTypeExcel9,_      "data",myFile,True,arr(iSht)   Next   .CloseCurrentDatabaseEndWithApplication.ScreenUpdating=TrueMsgBoxmyFile&Chr(10)&"ExportisDone！"SetAppAccess=NothingEndSub