Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 µÄ»Ø¸´:
Óõ¼Èëµ¼


Ïà¹ØÎÊ´ð£º

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

ÇóACCESSÊý¾Ý¿â

      ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
  ¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË

officeÍêÕ ......

ʹÓÃRepeater¶ÁÈ¡access±í£¬Ò³Ãæ´ò¿ª·Ç³£Âý

accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í  ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......

_access ÇëÎÊÕâ¸öº¯ÊýÊǸÉÂïÓõģ¿

ËüµÄ¶¨ÒåÊÇÕâÑùµÄ


_CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode);



´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿

´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅж ......

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ