accessÊý¾Ý¿âµÄÎÊÌ⣬ÇóÖú~~~~~~~~~~~~~~~~~~~~~~~
ÎÒÓÐÁ½¸öaccessÊý¾Ý¿â£¬¼ÙÉè:a1.mdb£¬a2.mdb ËüÃǶ¼ÓÐÒ»ÕŽṹһÑùµÄ±íproduct,ÎÒÏë°Ña2.mdbÀïÃæµÄproductµ¼Èëµ½a1.mdbµÄproductÀïÃæÈ¥£¬ÈçºÎʵÏÖ¿ìµã£¿Íû¸ßÊÖµãÏ¡£
ÒýÓà Óõ¼Èëµ¼³ö²»ÐÐ?? ÎÒÒ²²»ÖªµÀÐв»ÐУ¬Ã»ÊÔ¹ýѽ¡£ ¶ÔÁË£¬Ã»ÓÐ˵Çå³þ£¬ÓÐһЩÄÚÈÝÐèÒª¹ýÂË£¬ÎÒ¿´Ó¦¸ÃÔÚ³ÌÐòÀïÃæ´¦Àí»áºÃÒ»µã°É¡£¡£ select³öÀ´£¬¸Ã¹ýÂ˵ĹýÂË£¬È»ºóÔÚinsert½øÈ¥£¬ÕâÑù¿ÉÒÔ°É¡£¡£ÒýÓà SQL codeinsertinto productselect*from[c:\test\a2.mdb].product лл°¡£¬¿ÉÒÔÕâôʵÏÖÄǸü¼òµ¥ÁË£¬accessÊÇ·ñÓÐreplaceº¯ÊýÄØÒýÓà ÒýÓà 3 Â¥ qq175691524 µÄ»Ø¸´: ÒýÓà 1 Â¥ sql77 µÄ»Ø¸´: Óõ¼Èëµ¼³ö²»ÐÐ?? ÎÒÒ²²»ÖªµÀÐв»ÐУ¬Ã»ÊÔ¹ýѽ¡£ ¶ÔÁË£¬Ã»ÓÐ˵Çå³þ£¬ÓÐһЩÄÚÈÝÐèÒª¹ýÂË£¬ÎÒ¿´Ó¦¸ÃÔÚ³ÌÐòÀïÃæ´¦Àí»áºÃÒ»µã°É¡£¡£ select³öÀ´£¬¸Ã¹ýÂ˵ĹýÂË£¬È»ºóÔÚinsert½øÈ¥£¬ÕâÑù¿ÉÒÔ°É¡£¡£ Ðа¡,ºÇºÇ,Èç¹ûÖ»Êǵ¼ÈëÊý¾ÝÓòéѯ¾ÍÐÐÁË,¹ýÂ˾ÍÓÃWHEREÌõ¼þ àÅ£¬¾ÍÊÇÈç¹ûacessÓÐreplaceº¯ÊýÄǾ͸üºÃÁË.²»Öªaccess¿ÉÓÐÕ⺯ÊýÒýÓà лл°¡£¬¿ÉÒÔÕâôʵÏÖÄǸü¼òµ¥ÁË£¬accessÊÇ·ñÓÐreplaceº¯ÊýÄØ ACCESSÖÐÓУ¬µ«½öÄÜÔÚACCESSÄÚ²¿Ê¹Óã¬Äãͨ¹ýADOÔòÎÞ·¨Ê¹ÓÃÕâ¸öº¯Êý¡£ÒýÓà ÒýÓà 5 Â¥ sql77 µÄ»Ø¸´: ÒýÓà 3 Â¥ qq175691524 µÄ»Ø¸´: ÒýÓà 1 Â¥ sql77 µÄ»Ø¸´: Óõ¼Èëµ¼
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿ <%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿ ¸øÐ¡µÜÒ»¸ö£¡ °²×°OFFICEʱѡÔñ°²×°ACCESS °²×°OFFICEʱѡÔñ°²×°ACCESS °²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË officeÍêÕ ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡ Ò»´ÎÈ«²¿¶ÁÍê ......
ËüµÄ¶¨ÒåÊÇÕâÑùµÄ _CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode); ´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿ ´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅж ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......