ACCESSÖн¨Á¢Çл»±íµ¥Ê±Óöµ½ÎÊÌâ ÔÚÏßµÈ
ACCESSÖн¨Á¢Çл»±íµ¥,
µã»÷ ¹¤¾ß/×ÊÁϿ⹫ÓóÌʽ/Çл»±íµ¥¹ÜÀíÔ± ºó
Ìáʾ£ºMicrosoft office accessÎÞ·¨½¨Á¢visual basicÄ£×飡
µ½µ×ÊdzöÁËʲ÷áÎÊÌâÄØ£¿
µÚÒ»´ÎÕâÑù½¨Á¢Çл»±íµ¥ÊÇ¿ÉÒԵ쬵«ÊÇÓÉÓÚÓиö°´Å¥²»Äܵ㣬ÎÒ¾ÍɾÁËÖØÐ½¨£¬¾Í³öÏÖÕâ¸öÌáʾÁË£¬Ð»Ð»···
Ïà¹ØÎÊ´ð£º
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
ÎÒдÁËÒ»¶Î£¬µ«ÊÇÓеãÎÊÌâ¡£°ïæ¿´¿´¡£
<%
action=request("action")
if action="make_excel" then'Ö»ÓлñȡָÁî²Å½øÐвÙ×÷ ......
accessÊý¾Ý¿â¡£ÓÐÁ½¸ö±ía£¬b
a±í±£´æÁ˺ܶàѧУµÄÐÅÏ¢
b±í±£´æÁËѧУ±¨ÃûµÄÐÅÏ¢£¬Ò»¸öѧУ¿ÉÒÔ±¨nÌõ
ÒªÇóÊä³öËùÓÐѧУµÄ±¨Ãû¼Ç¼ÊýÁ¿È磺
¼×У 25
ÒÒУ 50
±ûУ 50
¶¡Ð£ 70
.
.
.
......
СµÜÎÒÔÚдһ¸öÆû³µÐÞÀí³ÌÐòµÄʱºòÓö¼ûÁËÒ»¸öÎÊÌ⣬ÎҵĴ洢ģʽÊÇÕâÑùµÄ£¬³µÁ¾ÐÅÏ¢´æ·ÅÔÚÒ»ÕűíÄÚ£¬³µÁ¾Î¬Ð޼ǼÊÇÿ¸ö³µ´æ·ÅÒ»ÕűíÈçÏÂËùʾ£º£¨±í1 µÄ±íÃûÊÇ¡°Î¬ÐÞÕËÄ¿¡±£¬±í2µÄ±íÃûÊÇ ³µÅƶÔÓ¦µÄIDºÅ£©
  ......
¸÷λ´óÏÀ£º
ÔÚ´°ÌåÀïÓÐÒ»Áбí¿ò£¬ÃûÔ»¡°ÉÌÆ·±àºÅ¡±£¬ÐÐÀ´Ô´ÀïµÄÄÚÈÝÓУºÉÌÆ·±àºÅºÍÉÌÆ·Ãû£¨À´×ÔÉÌÆ·±í£©¡£
µ«ÊÇÎÊÌâ³öÏÖÁË£ºÔÀ´ÉÌÆ·±íÀïµÄÉÌÆ·±àºÅÊÇ4λ£ ......