ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦óÅýEXCEL VBA±qAccessŪ¸ê®Æ­pºâ©O¡H

[µo°Ý] ¦p¦óÅýEXCEL VBA±qAccessŪ¸ê®Æ­pºâ©O¡H

access.png
2017-4-5 19:54
vba.png
2017-4-5 19:54


Á|¨Ò¡G
¦p¹Ï¡A§Ú¦bAccess¦s¨ú¤F¤@ÀɪѲ¼¤Q¤Ñªº¸ê®Æ¡A·Q¥ÎVBAª½±µ¤Þ¥Î¼Æ¾Ú­pºâ
¤£ª¾¹D¬O§_­n¥ý§â¼Æ¾Ú¾É¤J¨ìExcel³æ¤¸®æ¤¤¤~¯à¤Þ¥Î­pºâ¡AÁÙ¬O¯à¼g¥N½X¦bVBAµe­±¤¤ª½±µ¤Þ¥Î©O¡H

¤ñ¸û¤£µ½ªí¹F¡A¨D¦U¦ìÀ°¦£¡AÁÂÁ¡C

«Øij¦baccess¤¤¥ý¹Bºâ¦n¡A¦s¦¨table (ex: stock_analysis)¡A
¦A¥ÎVBAÂà¨ìexcel´N¦n
DoCmd.TransferSpreadsheet acExport, 8, "stock_analysis", "D:\stock.xls", True, ""

TOP

¦^´_ 2# alexjeng


    ÁÂÁ¦^ÂÐ
¦³¸Õ¹L§Aªº¤èªk¡A¦ý¦]¬°ªÑ²¼ªº¼Æ¾Ú¬OŪ¨úDDEªº¡A¦Ó¥B¦pªG°O¿ýªº¤Ñ¼Æ¶V¦h°j°é·|¶]«ÜºC
©Ò¥H¤~·Q°Ý¦³¨S¦³¯àª½±µ¤Þ¥Î­pºâªº¿ìªk

TOP

¥i¥H¥Îexcel¥h¿ý»s "¶×¤Jaccess" ªº³¡¤À
¿ý»s¶×¤J¤@­Ótable«á
±N¿ý»s¦nªºVBA­×§ï¦¨°j°é´N¥i¥H±N¥þ³¡¤À¶×¤J¦Üexcel¤F

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD