excelvba编程24学时教程20（）

《excelvba编程24学时教程20（）》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、excelvba编程24学时教程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