資源描述：
《excelvba編程24學(xué)時教程20（）》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在工程資料-天天文庫。
1、excelvba編程24學(xué)時教程20()Thispaperiscontributedbywater335PdfdocumentmayattheWAPendofthebrowsingexperiencepoor?SuggestyouselectTXT,ordownloadthesourcefiletothemachineview.Introductionof20hourclassdataaccessInthissession,wewillbereadytousetheloadingmacrocalledMSQuery,anduseMSQuerytocreatequeriestoimpor
2、tdatafromanexternaldatasource?ThebiggestadvantageoftheMSQuerytoolisthatyoucanuseExceTsmacrorecordertorecordtheentireprocess?Thefocusofthisclassinclude:?Someofthediscussiontoretrievedatadatabaseformat?Tooutlinesomemethodstoretrieveexternaldata?HowtousetheMSQuerytoretrievethedatachangerecordedMSQu
3、erymacro?20.1availabledatabasesExCelcanbeusedinalmostalltypesofdatabase,enablingaccesstothedatainthedatabase?Thefollowingisalistofsomeofthemtobeabletousethedatabaseformat:Microsoft?Access?MicrosoftSQLServer?MicrosoftFoxPro?Oracle?Paradox?DBASE?ASCIItextf訂e?SYLKyoumightconsider,whyneedtoputthedat
4、aintotheExceldatabase?Whendealingwithcertainthings,Excelcandobetterthanthedatabase,whichincludescomputing,analyzingandplottingcharts?AfterthedataintotheExCEL,canprocessExceldatausingtheseadvantages?20.2dataaccessmethodInfact,you'veappliedadatabaseaccessmethodthatcanbeusedinExCEL,andPivotTablecan
5、beusedtoimportexternaldataintoExce1.TheexternaldataintoothermethodsofExcelinclude:MS?Query?ADO(ActiveXDataObjects,ActiveXdataobject(Data)?DAOAccessObjects,dataaccessobject(Open)?ODBCDatabaseConnectivity,opendatabaseconnectivity)quickandeffectiveaccesstothebestmethodofMicrosoftAccessandotherdatai
6、nthedatabaseisusedADO.ThemainsupportDAOforbackwardcompatibilitywithearlierversionsofAccess.ODBCcanbeusedtoconnectavarietyofdatabases,includingMicrosoftSQLand0raCLE?ThiscoursewillfocusontheuseofMicrosoftQuerytotheexternaldataintoIntroductionandapplicationoftwentiethhourclassdataaccessOnehundredan
7、dsixty-nineMethodsinExceL20.1useMSQuerytoaccessdataFromthemostsimplemethodofExCELisusedtoaccessexternaldatacalledMSQueryadd?MSQueryisatoolthathelpsusersconnecttodatasourcesandretrievedatafromadatasource,andtheretrieveddatais
