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导入一个工作簿下的所有工作
表
关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf
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