Excelã§ã¯ããŒãã«ãšã¯ãšãªã掻çšãããšæ¥œã«ãªã
çŸåšãæ°å ¥ç€Ÿå¡åãã®Excelãã¬ãŒãã³ã°äžçŽç·šè¬åº§ãäœæããŠããŸããä»åã®ææã¯ã¹ã©ã€ãè³æãè¬çŸ©çšã®ãµã³ãã«ãã¡ã€ã«ãå®è·µèª²é¡ããããŠåç»è³æã®ïŒæ¬ç«ãŠã§æ§æããŠãããå 容ãããªãæ¿åãªãã®ã«ä»äžããŠãŸãããŸã ãåç»è³æãå šéšã¢ããããŠããªãã®ã§äžå®å šã§ããããã以å€ã¯ããããçšæã§ããŸããã
ãã®è¬çŸ©é ç®ã®äžã§ä»åãäžçªåŠãã§ããããããã®ããããŒãã«ãšã¯ãšãªãã§ããå®éã®å®åã®çŸå Žã§ã¯é©ãã»ã©äœ¿ãããŠãªãã£ããããŸãããããŠããããæ ã«ãã¹ããããããŸãå€ãæãè³æãåèã«ããŠå€å žçãªãã¯ããã¯ã§ä¹ãåã£ãŠãã®ãçŸç¶ã§ããããã身ã«ã€ããã°ãä»ããããã£ãšæ¥œã«ãªãããšè«ãåãã§ãã
ç®æ¬¡
ä»å䜿çšããExcelã·ãŒã
é¢åããããã°ã«ééããã»ã»ã»
ããŒãã«ããã³ã¯ãšãªãã€ãã£ãæã«ããäžå®æ¡ä»¶ã§ããŒã¿ãæœåºããå Žåã«ãããŠãExcel2013ãExcel2016ãªã©ã§ãã»ã«ã«æåãå ¥åæã«ã1æåç®ãåæã«ç¢ºå®ãããããšããçŸè±¡ãçºçããŠããŸãããã®åé¡ã¯éå»ã«ãExcelã«ãã£ãDropboxãåå ã§èµ·ããŠãããã®ãã詳现ãªããã¹ããµãŒãã¹ãåå ã§èµ·ãããã®ãIMEã®äºæž¬å€æãåå ã§èµ·ãããã®ã§ã¯ãªãããã®ããŒãã«ïŒå³å¯ã«ã¯PowerQueryã§å€éšãœãŒã¹ããæœåºããæã®ããŒãã«ïŒãåå ã§èµ·ããèŽåœçãªãã°ã®ããã§ããmacOSçã¯åããã¡ã€ã«ã§ãåé¡ãèµ·ããŠããŸããã
å ·äœçãªçŸè±¡ã¯ä»¥äžã®éã
- å€éšã®MDBãªã©ããããŒã¿ãPowerQueryã§æœåº
- ããŒã¿ã®æŽæ°ã«é¢ãããªãã·ã§ã³ã«ãŠããããã¯ã°ã©ãŠã³ãã§æŽæ°ãããã«ãã§ãã¯ãå ¥ã£ãŠãããšèµ·ããŸãã
ãã®åä»ãªåé¡ãåé¿ããæ¹æ³ã¯ä»¥äžã®2ãã¿ãŒã³ã§ãã
- 察象ã®ããŒãã«ãå³ã¯ãªãã¯âããŒãã«âããŒã¿ãœãŒã¹ãšã®ãªã³ã¯ãè§£é€ã§åé¿ïŒãã ãããªã³ã¯ãåæãããããšã«ãªãïŒ
- ããŒã¿ã¿ãã®æ¢åã®æ¥ç¶â察象å³ã¯ãªãã¯ã§æ¥ç¶ããããã£ã®ç·šéâããã¯ã°ã©ãŠã³ãã§æŽæ°ããã®ãã§ãã¯ãå€ãïŒèŠªããŒã¿ãæŽæ°ãããŠãèªåæŽæ°ãããªãïŒã
ãšãã£ãã¡ãã£ãšèŽåœçãªãã°ã§ããããããšå ¥åããŠäœãããã«åæã«ç¢ºå®ããŠããŸãã®ããã®ãã°ã®çç¶ã§ããå®éã«1.ã®æ¹æ³ã§åæãè¡ããšããã®çç¶ã¯èµ·ããŸãããç¹å®ã®ããã¯ã§ã ãããªããæ¥æ¬èªå ¥åãããããªãšããæã¯ããŸãããŒãã«ã®èªåæŽæ°ãªãã·ã§ã³ãçã£ãŠã¿ãŠãã ããã
å³ïŒåä»ã§éåžžã«ã¹ãã¬ã¹ãã«ãªãã°
ããŒãã«
ä»åã®ãšã³ããªãŒã®äžã§äžçªã®ç®çãããŒãã«æ©èœã§ããæŽå²ã¯æå€ãšå€ãExcel 2000(ã³ã¡ã³ãããä¿®æ£ããŸããïŒããç»å Žãããã®ã§ããããŒãã«ãšããååãããããããã«ãAccessã®ãããªããŒã¿ããŒã¹ã®ããŒãã«åœ¢åŒã«ããŠExcelã®ã·ãŒããäœ¿ãæ©èœã§ããããã䜿ãããªããã°éåžžã«æ¥œã«äœæ¥ãé²ããããšãã§ããŸããããããExcelããã ã®ç»é¢ã¬ã€ã¢ãŠãã®æ¹çŒçŽçšåºŠã«ããæããŠãªã人ã ãšããã®ä»çµã«æ«æããããšãããããã§ãïŒAccessã§æ«æãã人ãåºãã®ãåãçç±ã ã£ããããŸãïŒã
ããŒãã«åã®æ¹æ³
ããŒãã«åããã®ã¯é©ãã»ã©ç°¡åã§ãã以äžã®æé ã§è¡ããŸããã»ã«ã®çµåãªã©ã¯äœ¿ããªãããã«ããŸãã空è¡ãªã©ã¯å ¥ããªãããã«æ³šæãå¿ èŠã§ãã
- ãã¡ãã¡æŽåœ¢ãããŠããããŒã¿ã®ç¯å²ãæå®ãã
- æ¿å ¥ã¿ãã«ãããããŒãã«ããã¯ãªãã¯
- å é è¡ãèŠåºãã«ããã«ãã§ãã¯ãå ¥ã£ãŠããã°èªåã§ãã£ã«ã¿ãä»ããŸã
- ããã§OKãã¯ãªãã¯ããã°ããŒãã«åå®äº
- ãã¶ã€ã³ã¿ããéãããããŒãã«åãã«ãŠãããŒãã«ã®ååã倿Žã§ããŸããããããããååãã€ããŠãããŸãããã
- å¹ ãèªåä¿®æ£ãããããã«ãªããŸãã
- ããŒãã«è§£é€ããå Žåã¯ãå šç¯å²æå®ããŠãå³ã¯ãªãã¯âããŒãã«âç¯å²ã«å€æããã°å ã«æ»ããŸãã
å³ïŒããŒãã«ã®ååã¯æ°åŒãäœãæã«å©çšããŸã
ããŒãã«åã§é¢æ°ã®èªåè£å®
ããŒãã«åããã¡ãªããã®äžã€ããã®ã颿°ã®èªåè£å®ããAccessã䜿ã£ãŠã人ã¯ããããšæããŸãããããŒãã«ã§ã¯ã»ã«åäœã§ã¯ãªãååäœã§é¢æ°ã管çããããšã«ãªããŸãããã£ãŠãïŒè¡ç®ã®ç¹å®ã®ã»ã«ã«æ°åŒãå ¥ãããšããã®åãã¹ãŠã«æ°åŒãèªåã§è£å®ãããŸãããŸããè£å®ãããæ°åŒã¯åºæ¬ãã¹ãŠåãæ°åŒã«ãªããŸãïŒéåžžã®ç¯å²ã®å Žåã«ã¯ãã»ã«çªå°ãããããç°ãªãïŒããããæ§é ååç §ãšåŒã³ãŸãã
ãã®ãããïŒè¡ç®ã®æ°åŒã倿Žããã°ããã¹ãŠã®è¡ã®çµæã倿ŽãããŸãããŸããvlookup颿°ã®ãããªæ°åŒã®å Žåãåç §å ã®ããŒã¿ãããŒãã«åããŠããã°ããç¯å²ãåºå®åããŠããªãã£ãçºãå€ããºã¬ãŠå€§å€ãªããšã«ããšãã£ãäºãé²ããŸãããªããªãã°ãããŒãã«ã§åç §ãããŠããããã§ãã
ã¬ã³ãŒãã远å ããŠãèªåã§æ°åŒãè£å®ããæ¡åŒµãããã®ã§ãã¡ã³ããã³ã¹ãäžèŠã«ãªããŸãã
å³ïŒæ°åŒã®ç®¡çããšãŠã楜ã«ãªã
æ°åŒããããããããªã
颿°è£å®ã§ãããããã«ãæ°åŒã§ã¯ã»ã«çªå°ã«ãããã®ã§ã¯ãªãããŒãã«åã«ãããã®ã«ãªããããæ°åŒã®èŠéããéåžžã«ãããªããŸãããšãã«ãVLOOKUP颿°ã®ãããªè€éãªé¢æ°ã®å Žåããããé¡èã§ããä»åã¯ãindexã»matchã§çžŠæšªã¯ãã¹æ€çŽ¢ãäŸã«èŠãŠã¿ãŸãã
1 |
=INDEX(ããŒãã«1[[å è€é³Žæµ·]:[æ¢ å£å³°]],MATCH(I3,ããŒãã«1[æç§],0),MATCH(J3,ããŒãã«1[[#èŠåºã],[å è€é³Žæµ·]:[æ¢ å£å³°]],0)) |
ã»ã«çªå°ã§ã¯ãªãã®ã§ãäœãããŠããã®ããéåžžã«ãããããããªããèŠæãªindexã»matchã®çµã¿åããããããªãã°ãå ã ãšäœ¿ããããã«ãªãã§ãããã
å³ïŒããŒãã«ã ãšåç §ç¯å²ã®èŠéããéåžžã«ãããªã
å³ïŒæ°åŒå ¥åäžã¯ãã£ãŒã«ãåãåºãŠãã
ããããããŠã³ãªã¹ãã®èªåä¿®æ£
Excelã§ãããå©çšãããã¯ããã¯ã«ããããããŠã³ãªã¹ãããããŸããé ç®ãæå ¥åããã®ã§ã¯ãªãéžæããã ãã§è¯ãã®ã§ãå ¥åãã¹ãæžããææ®µãšããŠåžžå¥ææ®µã§ããããããããã®ããããããŠã³ãªã¹ãã¯ãã®ãªã¹ãã墿žããå Žåãæåã§æçŽããããªããã°ãªããŸãããããããšã£ãŠã鬱é¶ããã
ãããããããããŒãã«ãšãååä»ãç¯å²ãã®åããæã䜿ããšãã¡ã³ããã³ã¹ããªãŒã«ãªããŸãã以äžã®æé ã§èšå®ããŸãã
- ããŒã¿ãããŒãã«åããŠãã
- ãªã¹ãåããç¯å²ãéžæããæ°åŒã¿ãâååã®ç®¡çãéã
- æ°èŠäœæãã¿ã³ãã¯ãªãã¯
- ååã¯ãããããããã®ãã€ããŠããããããŠãOKãæŒããä»åã¯è»åãšããç¯å²ãä»ããŸããã
- ãªã¹ãèšçœ®ããã»ã«ãéžæããããŒã¿ã¿ãâããŒã¿ããŒã«âããŒã¿ã®å ¥åèŠåãã¯ãªãã¯ããŸãã
- å ¥åå€ã®çš®é¡ãããªã¹ããã«ããŠãå ã®å€ã§ã¯F3ããŒãæŒããšãå çšã€ããååä»ç¯å²ãåºãŠããã®ã§éžæã
- OKãæŒãã°ããããããŠã³ãªã¹ãã«ããŒãã«åããååä»ãç¯å²ãé©çšãããã
- 1.ã®ããŒãã«ã®æäžè¡ã«ïŒè¡ããŒã¿ã远å ããŠã¿ã
- 7.ã®ããããããŠã³ãªã¹ããèªåã§æ¡åŒµãããŠãªã¹ããå¢ããŠãã
ããã¯ãããŒãã«ã®æ©èœã®ïŒã€ã§ãèªåã§ã¬ã³ãŒãã远å ãããšããŒãã«ç¯å²ãèªåã§æ¡åŒµããæ©èœãå©çšãããã®ã§ããããã«å¯ŸããŠååä»ãç¯å²ãèšå®ããŠããã®ã§ãååä»ãç¯å²ãèªåã§æ¡åŒµããã®ã§ãããããããããããŠã³ãªã¹ãã®ãªã¹ãã«äœ¿ã£ãŠããã®ã§ãããŒã¿ã远å ãããã°ãããã»ã©ããªã¹ãã¯èªåã§å¢ããŠããã®ã§ãïŒãã¡ãããåé€ããã°æ¶ããŠãããŸãïŒã
å³ïŒããŒãã«åãšååä»ãç¯å²ã®åããæ
å³ïŒãªã¹ãã®ç¯å²ã¯ã»ã«ç¯å²ã§ã¯ãªãååä»ãç¯å²ã䜿çš
ãªã¬ãŒã·ã§ã³ã·ãã
Accessã§ã¯ããªãã¿ã®ãªã¬ãŒã·ã§ã³ã·ããæ©èœãå®ã¯ããŒãã«åãããšExcelã§ã䜿ããããã«ãªããŸããããã䜿ãããšã«ãã£ãŠãvlookup颿°ãªã©ã䜿ãããšããïŒã€ã®ããŒãã«éãã²ãšã€ãªãã«ããããšãå¯èœã«ãªããŸããã¯ãšãªãäœãã®ãšå šãåãæèŠã§ããäœããéžæã¯ãšãªã®ãããªãã®ã§ã¯ãªãããããããäœããšãã«å€éšããŒãã«ãäœ¿ãææ®µã«ãªãã®ã§ã泚æã
ããã¯ããããããŒãã«ãšããŠäœãããšã«ãªãã®ã§ã以äžã®æé ã§äœæããŸãã
- ããŒã¿ã¿ãâããŒã¿ããŒã«âãªã¬ãŒã·ã§ã³ã·ãããã¯ãªãã¯
- ãã¹ã¿ãšãªãããŒãã«ãéžã³ããã®äž»ããããŒã«ãªããã£ãŒã«ããéžã³ãŸãã
- é¢é£ããŒãã«ã«ã¯åç §å ã®ããŒãã«ãšãã¹ã¿ãšåãå€ãæ ŒçŽããŠããã£ãŒã«ããéžã³ãŸãã
- OKãæŒãã°ãªã¬ãŒã·ã§ã³ã·ããã貌ããã
- æ¿å ¥ã¿ãâããããããŒãã«ã§æ°èŠäœæãã
- è€æ°ã®ããŒãã«ãåæãããã©ãããéžæã®ãã§ãã¯ãå ¥ããŠãã
- ãããããããŸããã¡ã€ã³ããŒãã«ã®å€ãåŒã£åŒµã£ãŠãã
- è¡ãåãå€ãããããèšå®ãããªã¬ãŒã·ã§ã³å ã®é ç®ã远å ããŠãã
- ãããšãïŒã€ã®ããŒãã«ãå ã«ãªã³ã¯ããå 容ã§ãããããããŒãã«ãäœãããã
å³ïŒAccessã§ã¯ããªãã¿ã§ããã
å³ïŒ2ã€ã®ããŒãã«ãå ã«åäœãããããããäœãã
Power QueryãæŽ»çšãã
Power Queryãšã¯æããããMSQUERYã®åŒ·åçã®ãããªãã®ã§ãExcelã®ããŒãã«ãå€éšãœãŒã¹ãå ã«ã¯ãšãªãäœã£ãŠæœåºããçºã®ããŒã«ã§ãExcel2016ããã¯æšæºã§æèŒãããŠããããŒã«ã§ãã2013ã§ã¯PowerQueryãšããã¢ãã€ã³ã§å®çŸãããŠããŸããããã®æ©èœã䜿ããšãæšæºã®Excelã ãã§éçšãããããé¥ãã«æ¥œã«ããŒã¿ã®æœåºãå®çŸã§ããŸãã
ããŒã¿ã®ãã£ã«ã¿ãããã€ãçšæã§ãã
倧æ¬ã®ããŒã¿ããŒã¹ã·ãŒããçšæãããããå ã«ããã€ãã®ãã£ã«ã¿ã«ãŒã«ãäœã£ãŠãããæœåºãå¯èœã§ãããã¡ããå€éšãœãŒã¹ãšããŠAccessãMySQLãªã©ããåŒã£åŒµã£ãŠããã®ãè¯ãã§ããããã¯ãšãªã¯ããäœ¿ãæœåºã¢ãã«ãçšæããŠããããšã§ããããããªãŒããã£ã«ã¿ãšã¯éããããŒãã«ããã倧æ¬ã®ããŒã¿ã倿Žããããšã圱é¿ãåããŠæœåºå 容ãèªåã§åæ ãããŸãã
- ããŒãã«ã®ç¯å²ãæå®ãã
- ããŒã¿ã¿ãã®ãããŒãã«ãŸãã¯ç¯å²ããããéžã¶ãšPowerQueryãç«ã¡äžãããŸãã
- ããããã£ã®ååã倿ŽããŠããããã®ããããã£ã¯ããã€ãæã£ãŠããããšãå¯èœã
- ãã£ã«ã¿ããããå¥ã®ããŒãã«ãšé£çµããããå¯èœã«ãªãïŒAccessã®éžæã¯ãšãªã®ãããªãã®ïŒ
- ä¿åããŠèªã¿èŸŒããã¿ã³ã®éããŠæ¬¡ã«èªã¿èŸŒãã«ãŠãåæ å ãæå®ã§ãã
- ãã¡ãããã¯ãšãªã§ã¯ãã䜿ããã°ã«ãŒãåããããããšãå¯èœã§ãã
- ã¯ãšãªãšèšã£ãŠãSQLæã§ã¯ãªãã®ã§ã詳现ãšãã£ã¿ãéããŠãSQLã®ããã«æžãããŠããããã§ã¯ãããŸããã
- äœã£ãŠãããã¯ãšãªã¯ãã¯ãšãªãšæ¥ç¶ãã¯ãªãã¯ããã°ãã€ã§ãåŒã³åºããç·šéãå¯èœã§ãã
å³ïŒæ¯åãã£ã«ã¿ããå¿ èŠã¯ãªããã¯ãšãªãšããŠäœã蟌ãã§ããã°è¯ãã ãã
ãããªãã¯ã¹å€æ
ããŒã¿ã§é æŽïŒïŒã£ãŠèšã£ãããåºããããšã¯ã»ã«ããŒã¿ããããããªã¹ã衚ã§ã¯ãªãéèšãããããããªãã¯ã¹è¡šãã ã£ãããšãäœåºŠããããŸãã人éã«ãšã£ãŠã¯éèšãããŠçžŠæšªã®ã¯ãã¹éèšã¯èŠãããã®ãããããŸããããããã°ã©ã ã§æ±ãããŒã¿ãšããŠã¯éåžžã«ãããããããŸãããããããã®è¡šã¯å ããŒã¿ããã£ãŠäœãããããããããŒãã«ã§ã¯ãªããsumifsãªã©ã§å å·¥ããããã®ã ã£ããããããã§ãã
ãããããã°ã©ã ã§äœ¿ãããããªã¹ã衚ã«å€æããå¿ èŠããããŸãããã®ããã«VBAãæžãã®ãé¢åããšããããšã§Power Queryã«ã¯ãåã®ããããè§£é€ããšããçŽ æŽãããæ©èœããããŸãã
- ãããªãã¯ã¹ãªããŒãã«ã®ç¯å²ãPower Queryã§éã
- åé ç®ã®éšåã ããéžæãã
- 倿âåã®ããããè§£é€ãã¯ãªãã¯ãã
- ãã¡ã€ã«âéããŠæ¬¡ã«èªã¿èŸŒããã¯ãªãã¯ãã
- 貌ãä»ãå ãæå®ãããšãªã¹ã衚ã«å€æãããŠè²Œãä»ãããã
å³ïŒçžŠæšªå€æãšã¯éããŸãã
Microsoft QueryãæŽ»çšãã
ãããŒãæããããããŒã«ããã®Microsoft QueryãPower Queryãšéã£ãŠããã®æèŠã¯Accessã®éžæã¯ãšãªã«éåžžã«è¿ããã®ã§ããªã¬ãŒã·ã§ã³ã·ããããè€æ°ã®ããŒãã«ãçµã¿åãããŠãããŒã¿ãããŒãã«ã§è¿ããŠãããæ©èœã§ãããã UIãWindows95æä»£ã®ãããªå€èãããã£ãŠãã¡ãã£ãšã¢ã¬ã§ãããæè»ãªããŒã«ã§ããã
ãã¡ãã®ããŒã«ã¯ãSQLæãªã®ã§åŸæãªäººã¯çŽæ¥ä¿®æ£ãšããã§ããã®ã§ãPower Queryããã䜿ããããããããã ãæ³šæç¹ããããŸãã
äœ¿ãæ¹ã¯ä»¥äžã®æé ïŒ2016ã®å ŽåïŒ
- ãªãã³ã®ã¡ãã¥ãŒããã[ããŒã¿]âããã®ä»ã®ãœãŒã¹ãâãMicrosoft Queryããéžã³ãŸãã
- ODBCæ¥ç¶èšå®ç»é¢ã®ãããªãã®ãåºãŸããããã«Excel Filesãšãããã®ãããã®ã§ãããããã¯æ§åœ¢åŒã®xls圢åŒãã䜿ããªãã®ã§ãããã§ã¯æ°èŠããŒã¿ãœãŒã¹ãéžã³ãOKãæŒããŸãã
- ããŒã¿ãœãŒã¹ã®ååã¯é©åœã«ã察å¿ãããã©ã€ããŒã®éžæã§ã¯ãMicrosoft Excel Driverã§xlsxãxlsmã䜿ãããã®ãéžæããŸãã
- æ¥ç¶ãã¿ã³ãæŒããŸã
- 次ã®ãã€ã¢ãã°ã§ã¯ãããã¯ã®éžæãã¿ã³ãã¯ãªãã¯ããŸããExcelã®Versionã¯ä»åã¯12.0ãéžãã§ããŸãã
- ãã¡ã€ã«ãéžæããŸãããã®æèªåèªèº«ã®ãã¡ã€ã«ãéžã¶äºãå¯èœã
- OKãã¿ã³ãæŒããŸãã
- ããŒã¿ãœãŒã¹æšæºã®ããŒãã«ïŒã·ãŒãåïŒãéžã³ãOKãæŒããŸãã
- æåã®ç»é¢ã«æ»ã£ãŠããã®ã§ãOKãæŒããŸãã
- 次ã«8.ã§éžãã ããŒãã«ã®ãã¡ã䜿çšãããã£ãŒã«ãïŒååïŒãéžã³ãŸãã
- 次ãžãã¯ãªãã¯ããŸãã
- ããšã¯ãœãŒãã®æå®ããæœåºæ¡ä»¶ãå ¥ããããŸããæ¬¡ãžãã¯ãªãã¯ã
- æåŸã«ãã®ãŸãŸExcelã«ããŒã¿ãè¿ããŸãããèšå®ãæ¡åŒµåqryãšããŠä¿åãå¯èœã§ãããã ãããã§ã¯ç¶ããŠMicrosoft Queryã§ç·šéãããã®ã§Microsoft Queryã§ããŒã¿ã®è¡šç€ºãŸãã¯ã¯ãšãªã®ç·šéãè¡ããã¯ãªãã¯ããå®äºãã¿ã³ãæŒãã
- ãããšã¯ãšãªç·šéç»é¢ãåºãŠãããå¥ã®ã·ãŒããè¶³ããŠãªã¬ãŒã·ã§ã³ã·ãããçµãã ããæ°ãã«åã远å ãããããªããããããªããšãå¯èœã
- ããŒã¿ãè¿ããã¿ã³ãæŒããšãç¯å²æå®ã«ãªãããŒãã«ãšããŠããŒã¿ãExcelåŽãžãšè¿ã£ãŠããŸãã
- å床線éãããå Žåã«ã¯ãããŒãã«ãéžã³ã[ããŒã¿]â[æ¥ç¶]ãã¯ãªãã¯
- ããããã£ãã¯ãªãã¯ãã
- 次ã®ãã€ã¢ãã°ã®å®çŸ©ãšããã¿ããã¯ãªãã¯ããã
- æ¥ç¶æååãODBCæ¥ç¶æååã§ãã³ãã³ãæååãSQLæã§ããã¯ãšãªã®ç·šéãã¿ã³ãã¯ãªãã¯ãããšã10.ã®é ç®ãåºãŠããã®ã§ããŸãåãæé ããã©ã£ãŠMicrosoft Queryã§ç·šéãå¯èœã§ãã
å³ïŒããŒã¿ãœãŒã¹èšå®ã次å以éã¯éžã¶ã ãã§äœ¿ãã
å³ïŒã¯ãšãªç·šéç»é¢ãAccessã®ããã«äŒŒãŠãã
å³ïŒåç·šéæã®ããããã£ã®ç»é¢
ããŒãã«ã®æ©èœã¯Excel2000ã§ããããŸããã
ãã®é ãããã£ããšã¯ããä¿®æ£ããŸããã
ããããšãããããŸãã97ã®é ãã䜿ã£ãŠãŸããããæ°ãä»ããªã£ãã§ãã
1æåç®ã確å®ããããã°ã«ã€ããŠã§ãããâããã¯ã°ã©ãŠã³ãã§æŽæ°âã®ãã§ãã¯ãå€ããŠãæåæŽæ°ããæç¹ã§åçºããŸããåœæ¹Excel2016ã䜿çšããŠããŸãã
ç§ã®äœ¿ãæ¹ã¯ãåºæ¬ããŒã¿ãExcelãã¡ã€ã«ã®ããŒãã«ã«æ ŒçŽããŠããããããä»ã®è€æ°ã®Excelãã¡ã€ã«ã®ããŒãã«ã«æåã§åã蟌ããšããäºãè¡ã£ãŠããããããã¯ãšãªã§å®çŸããŠæåæŽæ°ããŠäœ¿ã£ãŠããŸãããïŒå¹Žã»ã©åé¡ãªã䜿çšããŠããŸããããæè¿ã«ãªã£ãŠãã®ãã°ãåé¡ãšãªãå°ã£ãŠããŸãã
ããŒã¿ã®æŽæ°ãé©æå¿ èŠãšãªããããªã³ã¯ãè§£é€ããäºã¯ã§ãããããã¯ã°ã©ãŠã³ãã§ã®æŽæ°ã¯å¿ èŠãããŸããããæåæŽæ°ã¯å¿ é ã§ãã
[ããŒã¿]-[ã¯ãšãªã®è¡šç€º]ã§ã¯ãšãªã®ãªã¹ãã衚瀺ããŠããã°çºçããªãäºãŸã§ã¯çªãæ¢ããŸããã®ã§ãçŸåšãã®ãªã¹ãããã¡ã€ã«ãéããæã«èªåçã«è¡šç€ºããææ®µã暡玢äžã§ãã
森æ§
ãããªãã§ãããããªã³ã¯è§£é€ãšãªããšèŽåœçãªã±ãŒã¹ã¯äºåã®çŸå Žã§ãæ®éã«ããã®ã§ããããããªäºäŸã§ã
ãããŒã®ãªã¹ã衚瀺ã§ã察å¿ã§ãããããããããŠããŠãããããŸããããè¯ããã¯ããã¯ããã§ãã
VBAã§ãã®èŸºããèªåçã«è¡šç€ºã§ããªãã®ããªããšæãæ¬¡ç¬¬ã§ãããŸã ãŸã 2016ãããã ãšçŸåœ¹ã§äœ¿ã£ãŠãæ