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

[µo°Ý] ¯à§_¨Ï¥ÎVBA ¦Û°Ê±NExcel ¸ê®Æ²Ö¿n¨ì Access ¸ê®Æ®w¤¤

[µo°Ý] ¯à§_¨Ï¥ÎVBA ¦Û°Ê±NExcel ¸ê®Æ²Ö¿n¨ì Access ¸ê®Æ®w¤¤

½Ð±Ð¥ý¶i¡G
  ­ì¥»¨Ï¥ÎExcel ¤u§@ªí§@¬°¸ê®Æ®w¨Ó°O¿ý¸ê®Æ¡A¦ý¦]¸ê®Æ¤ñ¼Æ¯}ªí(¶W¹L65536)¡A
  ©Ò¥HÂà¦Ó±N¸ê®Æ¶×¤J¨ì Access¸ê®Æ®w¤¤¡A¦ý¬O¦]¸ê®Æ¿é¤J¹Lµ{¦³¤@¨Ç¥¨¶°°õ¦æ¡A
  ¦]¦¹¤´µM±N·s¸ê®Æ¿é¤J¨ìExcel ¤u§@ªí¸ê®Æ®w¤¤¡A¦ý©w®É­n¥h¶i¦æÂà¶×¤J¨ì
  Access¸ê®Æ®wªº°Ê§@¡A·Q½Ð±Ð ¥ý¶i¡A¦³µL¥ô¦óªº½d¨Ò¥i¥H´£¨Ñ°Ñ¦Ò¡A
  §Q¥Î VBA ©w´Á¦Û°Ê±NExcel ¸ê®Æ²Ö¿n¨ì Access ¸ê®Æ®w¤¤¡H
  ³o­Ó°ÝÃD¡A§xÂZ§Ú«Ü¤[¡A¦]¬°¹ï Accessªº¾Þ§@¨Ã¤£¼ô.....
   ÁÂÁÂ

JS

¬O§_¬O§Úªº °ÝÃD ¤£°÷©ú½T¡H³£¨S¦³¥ô¦ó¦^À³¡H¡H¡H¡H
ÁÙ¬O Excel VBAµLªk±±¨î Access ¸ê®Æ®w¡A¥²¶·±q Access ¤U¤â¡H
­Y¬O¦p¦¹¡A¦³µL Access ¦Û°Ê¶×¤J Excel ¸ê®Æªí ªº½d¨Ò ©Î ¬ÛÃöªº¨BÆJ»¡©ú¡H
ÁÂÁÂ

TOP

¦^´_ 1# jsleee

¬Ý¹L«Ü¦h±Ð Excel VBA ªº®Ñ³£¦³´£¤Î§â Excel ¸g VBA §â­n¥Îªº¸ê®ÆÂà¨ì Access Àx¦s,
¦ý§Ú¦Û¤v¬Oªì¤ßªÌ,
¹ï³o¤@³¡¥÷¤£¤Ó²M·¡, ¹ï Access §ó¬O...
¦ý§Úª¾¹D¬O¥i¥H°µ±o¨ìªº.
©Î¥i¨ì¤U­±ºô­¶¬Ý¬Ý¯à§_À°¨ì§A

http://tgw1029.blogspot.com/2010/01/excel-vba-adoaccess_06.html
http://blog.xuite.net/crdotlin/excel/9056917

TOP

¦^´_ 3# jimmyhk

ÁÂÁ jimmyhk ´£¨Ñªº¸ê°T¡A§Ú·|¦n¦n¬ã¨s....

TOP

¦^´_ 4# jsleee


§A«È®ð¤F,
§Úªñ¨Ó«Ø¥ß¤F¤@­Ó¸ê°T®w,
¬O¥H Excel ¿é¤J, ³B²z«á¦A¿é¥X¨ì¥t¤@­Ó Excel Àɤº.
¤é«á±N¦Ò¼{¤É¯ÅÂà¦s¨ì Access ¥h.
¥N§Ú¤é«á¦³®É¶¡¦AºCºCÆp¬ã¤@¤U~

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD