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

Ôõô°Ñ¿Í»§¶ËµÄaccessÊý¾Ý¶¨Ê±¶Áµ½·þÎñÆ÷Àï

ÔÚ¿Í»§¶ËÓиöaccessÊý¾Ý¿âa.mdb£¬ÀïÃæÓÐÕűítb1£¬Óжþ¸ö×Ö¶ÎÁ÷Ë®ºÅºÍ»ý·Ö

ÔÚ¾ÖÓòÍøÀïÓиö·þÎñÆ÷ipÊÇ192.168.1.88£¬ÔÚ·þÎñÆ÷Àï×°ÁËsql2000£¬ÀïÃæÒ²ÓÐÒ»Õűíaa£¬aa±íÀïÓжþ¸ö×ֶηֱðÊÇb1ºÍb2¡£Êý¾Ý¿âÃûÊÇyy,

ÏÖÔÚÔõô°Ña.mdbÀïµÄÊý¾Ýÿ¸ô5·ÖÖÓ×Ô¶¯°Ñtb1ÀïÁ÷Ë®ºÅ×î´óµÄÊý¾Ý¶Áµ½·þÎñÆ÷ÀïµÄaa±íÀï¡£
¸ÉÂð²»Ö±½Ó°ÑÊý¾Ýдµ½SQL 2000À

ÒòΪÊÇaccessÊý¾Ý¿âÊÇÂòÉè±¸Ê±Ëæ»úµÄÈí¼þ¡£Ë­ÄܸøÐ©Àý×Ó¡£


Âé·³ÄãЩ´úÂëÀý×Ó¡£

ҲѧϰһÏ£¬¹Ø×¢£¡



ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!




Ïà¹ØÎÊ´ð£º

ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

access ²éѯ¼Ç¼µÄÎÊÌâ?

ÎÊÌâÈçÏ£º

ÓòéѯÓï¾ä
select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´
¸ÄΪ
select * from tab where fil = 'CK090902'
¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......

¹ØÓÚEXCELµ¼ÈëACCESSµÄÎÊÌâ

  EXCELÖÐÓÐÒ»ÁÐÊý×ÖÈçÏ£º          µ¼Èëµ½ACCESSÒÔºó
      ²ÄÁÏ                        &nb ......

sqlÖÐÀàËÆÓëACCESS instrº¯ÊýµÄº¯Êý£¿

ÐͺŠ               ³¤¶È
ABC-12B1.3          2
ABC-24B1.0          3
ACD-100B1      ......

vb.net¸üÐÂACCESSÊý¾Ý¿â±¨´í£¬Çë½Ì¸ßÊÖ£¡

½öÊÇÒ»¶Î¸üÐÂÃÜÂëµÄ´úÂëÈçÏ¡£±¨´íÐÅϢΪ£º

δ´¦ÀíµÄ¡°System.Data.OleDb.OleDbException¡±ÀàÐ͵ÄÒì³£³öÏÖÔÚ System.Data.dll ÖС£

ÆäËûÐÅÏ¢: UPDATE Óï¾äµÄÓï·¨´íÎó¡£

µ¥¶ÀµÄINSERTÓïÑÔÔÚÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ