ÇëÎÊ£¬ÎªÊ²Ã´ÎÒ´ò¿ªACCESSµÄʱºòÈÃÎÒÊäÈëÃÜÂëÄØ£¿
Äã´ò¿ªµÄExcelÎļþÊÜÃÜÂë±£»¤µÄ
¼Ó¹ýÃÜÁË¡£
ÄÇÄã¾ÍÊäÃÜÂë
LZ ¿ÉÒÔÈ¥ google ËÑË÷һϡ°access ÃÜÂëÆƽ⡱£¬¿ÉÄÜÓаïÖú¡£
ÎÒÏëÄÇÊÇÒòΪËüÕæµÄÒªÃÜÂë°É¡£¡£¡£¡£
£¨access¼ÓÃÜÂëÁË)
ÄãµÄÕâ¸öÎļþ¼ÓÃܹý¡£¡£¡£
Ҫô°ÑÕâ¸öExcelжÁË£¬ÔÚ×°Ò»´Î¿´¿´
acc ......
Êý¾Ý±í×ֶΣºid£¨±àºÅ£©£¬ÊýÁ¿£¨num£©£¬Èë¿âʱ¼ä£¨date <yyyy-mm-dd>£©£¬
ÊäÈë±àºÅ£¬Á½¸öÏÂÀÑ¡Ôñ¿ò·Ö±ðÑ¡ÔñÄê·ÝºÍÔ·ݣ¬µã»÷²éѯ£¬
²éѯÊä³ö¸Ã±àºÅµ±ÔµÄÿÌõ¼Ç¼ֵ£¬²¢ÇóÊýÁ¿µÄºÏ¼Æ¡£
×Ô¼º¶¥ÏÂ
µÚÒ»²»ÖªµÀÄãÐèҪʲô£¿µÚ¶þΪʲôһ¸ö¼òµ¥µÄ²éѯҪ½«Äê·ÝºÍÔ·ݷÖΪÁ½¸öÏÂÀ¿òÀ´²Ù×÷£¬ÄãÍêÈ«¿ÉÒÔÓÃÈÕÀú ......
Õâ¶Î´úÂëÎÒ¾õµÃºÜºÃÓ㬽â¾öÁËaccessËæ¼´Ñ¡È¡nÌõ¼Ç¼µÄÎÊÌâ
µ«ÊÇÓиöÎÊÌ⣬Èç¹ûÊý¾Ý¿âÀïÃæÑ¡³öÀ´µÄ¼Ç¼×ÜÊý£¬Ð¡ÓÚÒªÏÔʾÊý ÈçItem=10
¾Í»á³¬Ê±
ÐèÒª¼Ó¸öÌõ¼þ£¬¾ÍÊÇÈç¹ûÊý¾Ý¿âÑ¡È¡³öÀ´µÄ¼Ç¼×ÜÊý СÓÚ ÒªÇóÏÔʾ¼Ç¼Êý
ÄÇô¾ÍÒÔÑ¡È¡³öÀ´µÄ×ÜÊýÏÔʾ...
°ÝÍÐÁË£¬ÎÒʵÔÚ²»Çå³þ¼Ó ......
ËüµÄ¶¨ÒåÊÇÕâÑùµÄ
_CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode);
´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿
´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅжÏÊÇ·ñÄÜÒÔijÖÖ·½Ê½·ÃÎÊij¸öÎļþÁË¡£
_access
int _access(
constchar*path,
......
ÀýÈç±¾»úIPΪ10.5.8.109,SQLÊý¾Ý¿â·þÎñÆ÷ÔÚ10.5.8.121.°ïæд¸öÀý×Ó.!
SQL Native Client ODBC Driver
±ê×¼°²È«Á¬½Ó
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
ÄúÊÇ·ñÔÚʹÓÃSQL Server 2005 Express£¿ ÇëÔÚ¡ ......
ÈçÌ⣬ÎÒÏëÔÚACCESS³ÌÐòÍ˳öµÄʱºò×öЩ²Ù×÷£¬±ÈÈ絯¸öMSGbox,¸ÃÔõô×ö?
Í˳öFORM£¿
²»ÊÇÍ˳öFORM.ÊǹرÕÕû¸öAccess³ÌÐò¡£
²»ÖªµÀÊÇ·ñ¿ÉÒÔ
¿ÉÒÔ
ÓÃAPI À´²¶×ãÍ˳ö
ºÇºÇ£¬ÄãÄܲ»ÄÜ°ï°³À´¸öʵÀý£¿
³ÌÐòÍ˳öÌáʾ ²Î¿¼Ê¾Àý
http://www.accessbbs.cn/bbs/thread-12552-1-2.html
......