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

±qexcel¤¤¥h§R°£access¸Ìªº¸ê®Æ

±qexcel¤¤¥h§R°£access¸Ìªº¸ê®Æ

½Ð±Ð¦U¦ì°ª¤â~
¥ý«e¦³°Ý¹L©³¦â¬O²`ºñ¦âªº¦b¥t¤@­Ó¤u§@ªí§@§R°£ªº°Ê§@
¨â­Ó¸ê®Æ³£¦bexcel¬O§¹¦¨¤F~

¦ý²{¦b·Q½Ð°Ý
­Y¤@­Ó¸ê®Æ¨Ó·½¬O¦bexcel¤@­Ó¬O¦baccess
¦bexcel¬O²`ºñ¦â©³ªº¸ê®Æ


­n¦p¦ó¦^¶Ç¦bACCESS¸Ì§R°£¤º®e


§Æ±æ¨âªÌ¹ïÀ³¨ìno. ³o­Ó·í§@key­È
¤]´N¬O»¡¨Ò¦p½s¸¹10001ªº¦bexcel¬O²`ºñ¦âªº©³
¦baccess¤]­n§R°£½s¸¹10001
¦Ó½s¸¹10003¦bexcel¬O¥Õ©³
©Ò¥H¤£­n¦baccess¤¤§R°£

ÁÙ¦³¤@­Ó·Qªk:
¬O§_¥i¥ýŪ¨ú²`ºñ¦âªº¸ê®ÆµM«á«Ø¥ß¤@­Óaccess¸ê®Æªí
¦A¥Îaccess sql»yªk¥h§R°£¬Û¹ïÀ³ªº­È

³Â·Ð¦U¦ì¤F~~~

¦^´_ 3# lpk187

¦³¨â­Ó©µ¦ùªº°ÝÃD~½Ð°ª¤âÀ°¦£¸Ñ´b
[²Ä¤@­Ó]
¥i¥Hª½±µ¦bexcel¤¤³]­Ó«ö¶sµM«á¥h§R°£access ¸ê®Æªí1 sys_date®É¶¡¬O2016¦~«eªº¸ê®Æ¶Ü?
³o¸Ó¦p¦ó³]¸m

¦pªþÀÉ: access.zip (19.23 KB) test.zip (27.4 KB)

[²Ä¤G­Ó]
¦baccess¤¤«È¤á¸ê®Æ¸ê®Æªí ¤w²Î¾ã·í¤Ñ·|­ûªº¶O¥Î
¦b¸ê®Æªí¤@¤¤§R°£§¹¿ù»~³æ«á
«È¤á¸ê®Æªº¶O¥Î¤]»Ý­n­×§ï
©Ò¥H·Q¨ìªº¤èªk¬O
¥ý§äaccess¤¤sys_date ¤é´Á¿ù»~¤u§@ªíªºsys_date¤@¼Ë
¦b§ä·|­û½s¸¹ access©Mexcel¤¤ªº¿ù»~¤u§@ªí¤¤ªº·|­û½s¸¹
«á¦A§â²Î¾ã¦nªº(access¤¤)¶O¥Î(fee) »P §R°£¿ù»~³æªºª÷ÃB(fee) ¬Û´î
³o­n«ç»ò°µ©O~
³Â·Ð±z¤F

TOP

¦^´_ 6# Changbanana

½Ð°Ñ¦Òhttp://forum.twbts.com/viewthread.php?tid=13681

¦ý¦³¥t¤@ºØ»¡ªk¬OAccessªº¯ÊÂI¡A­«ÂÐ "¶}±ÒÃö³¬" ¤ÓÃxÁc¦Ó¾É­P·¸¦ì²£¥Í»F¦¨ªº

TOP

¦^´_ 5# lpk187


³o¨â¤Ñ¦b¨Ï¥ÎdataAdd() ·s¼W¸ê®Æ¥\¯à®É
·|¥X²{Automation ³o­Ó°ÝÃD
¤£ª¾¹D¬O¨º¨à¥X¿ù¤F~
1.png

¥i§_À°¦£¤@¤U~ÁÂÁ§A^^

TOP

¦^´_ 4# Changbanana

¤W­±¨º­Óµ{¦¡¤£¥Î¸ÉªÅ­È°Ú¡I¸Ì­±¤º®e¤]¥i¥HÀH®É­×§ï¡C¤]¤£»Ý¥Î°}¦C
­nªÅ¥Õ¤]¥i¥HªÅ¥Õ¡A³o­Ó¤èªk¡A©M¤§«eªº¥þ¤£¬Û¦P¤]¨S¦³¥Î°}¦C¡ASub dataAdd() §ó¤£»Ý­×§ï¡B¼W¥[°}¦C
³o¦¸¥Îªº¡A¬O§Q¥Î.Recordset¨ä¤¤ªº»yªk¥h°µªº¡C´N¦n¹³ª½±µ¦baccess¤¤¾Þ§@¤@¼Ë¡A¦ý¤S¤£¬O¡I

TOP

¦^´_ 3# lpk187


ÁÂÁÂl¤j~«D±`·PÁ§A!!!!!!!

¦A½Ð±Ð¤@­Ó°ÝÃD¡A­Y¸ê®Æ¤¤¦³ªÅ­È ©Î¬O ªÅ­È¤H¤u¥ý¸É0
³o¼Ë¤lªº¸ê®Æ´NŪ¤£¶iaccess¤¤
©Ò¥H´N¹³±z¤§«e»¡ªº
ÈÐÀx¦s®æ¤¤¨S¦³¸ê®Æ¡A¦bVBA°}¦C¤¤¨Ã¤£·|¥H¬°¬ONull­È
¦ÓSQL»y¨¥¤¤«h¬O¥²¶·µ¹¥LNull­ÈÈÐ
©Ò¥H¦bSub dataAdd() ¨º¨à¡A´N­n¥[¤W°}¦C¥h§äªÅ­ÈµM«á¶ñ¤Wnull³o¼Ë¶Ü?

TOP

¦^´_ 2# Changbanana

¶}±Òtest.xlsmÀɮ׮ɡA½Ð¥ý¬Ý»¡©ú«á¡A¦A¾Þ§@
   
test.rar (42.95 KB)

TOP

¥»©«³Ì«á¥Ñ Changbanana ©ó 2016-9-9 21:31 ½s¿è

¦^´_ 1# Changbanana

excelªþ¥ó
excel.rar (95.69 KB)


accessªþ¥ó
access.rar (13.98 KB)

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD