±qexcel¤¤¥h§R°£access¸Ìªº¸ê®Æ
- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
±qexcel¤¤¥h§R°£access¸Ìªº¸ê®Æ
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
¥»©«³Ì«á¥Ñ Changbanana ©ó 2016-9-9 21:31 ½s¿è
¦^´_ 1# Changbanana
excelªþ¥ó
excel.rar (95.69 KB)
accessªþ¥ó
access.rar (13.98 KB)
|
|
|
|
|
|
|
- ©«¤l
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
|
¦^´_ 2# Changbanana
¶}±Òtest.xlsmÀɮ׮ɡA½Ð¥ý¬Ý»¡©ú«á¡A¦A¾Þ§@
test.rar (42.95 KB)
|
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
¦^´_ 3# lpk187
ÁÂÁÂl¤j~«D±`·PÁ§A!!!!!!!
¦A½Ð±Ð¤@Ó°ÝÃD¡AY¸ê®Æ¤¤¦³ªÅÈ ©Î¬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´Nn¥[¤W°}¦C¥h§äªÅȵM«á¶ñ¤Wnull³o¼Ë¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
|
¦^´_ 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 |
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
¦^´_ 5# lpk187
³o¨â¤Ñ¦b¨Ï¥ÎdataAdd() ·s¼W¸ê®Æ¥\¯à®É
·|¥X²{Automation ³oÓ°ÝÃD
¤£ª¾¹D¬O¨º¨à¥X¿ù¤F~
¥i§_À°¦£¤@¤U~ÁÂÁ§A^^ |
|
|
|
|
|
|
- ©«¤l
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
|
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
¦^´_ 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) ¬Û´î
³on«ç»ò°µ©O~
³Â·Ð±z¤F |
|
|
|
|
|
|