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

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

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



Á|¨Ò¡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 : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD