ÎÒÏÖÔÚaccess±íÖÐijһ×Ö¶ÎA ÓÐÏÂÃæµÄÄÚÈÝ(Ö»ÊǺóÃæµÄ²¿·Ö²»Ïàͬ)
1.http://www.google.cn/search?client=pub-475201884&forid=1&prog=aff&ie=GB2312&oe=GB2312&hl=zh-CN&q=ËûºÍËýµÄÄÐÈË
2.http://www.google.cn/search?client=pub-475201884&forid=1&prog=aff&ie=GB2312& ......
ÎÒдÁ˸ö²É¼¯³ÌÐò£¬Ôڲɼ¯µÄʱºò´ò¿ª²»ÁËÍøÕ¾£¬²É¼¯ÍêÁËÊý¾Ý¿âÊÍ·ÅÁ˲ſÉÒÔ´ò¿ª
ÇëÎÊÈçºÎ×öµ½²É¼¯ºÍä¯ÀÀ²»³åÍ»£¬Ò²¾ÍÊÇ˵²É¼¯Ê±ÍùÊý¾Ý¿âдÊý¾Ýʱ£¬Í¬Ñù¿ÉÒÔÕý³£¶ÁÈ¡Êý¾Ý £¿
ллÄãµÄ½¨Ò飬²»¹ý²»ÊʺÏÎÒÓÃ
ÒòΪÎÒ×öµÄÊÇ×Ô¶¯²É¼¯£¬Ò²¾ÍÊÇÖ»ÒªÓÐÈË·ÃÎÊÍøÕ¾¶¼»áÖ´Ðвɼ¯
ÄÇÑù²»¿ÉÒ﵀ ÒòΪÎÒµ ......
Dim datatable As New DataTable ½¨Á¢µÄÒ»¸öÄÚ´æ±í¡£
ÈçºÎ°Ñdatatable ±íÖеÄÊý¾Ý£¬±£´æµ½ACCESSÊý¾Ý¿â¡£×îºÃÓÐÀý×ÓºÍÔ´Âë
ÓÃoledbµÄÊý¾Ý¿âÁ¬½Ó¶ÔÏóºÍÊý¾ÝÊÊÅäÆ÷µÈ¶ÔÏó£¬Àý
string cnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source& ......
ÎÒµÄÏîÄ¿µÄ¼¸¸öÖØÒªµÄ±í·ÅÔÚÕâ¸öAccessÀï¡£Õ⼸¸ö±íÖ»¶ÁµÄ²»ÐèÒªÐ޸ġ£ÇëÎÊÓÐʲô·½·¨½ûÖ¹·¢ÉúÐÞ¸ÄÄØ£¿ÎÒÒª±£Ö¤Êý¾ÝµÄÍêÕûÐÔ¡£
2003 ÖпÉÒÔ½øÐÐÓû§×éµÄȨÏÞµÄÉèÖá£
ÎÒÖ»ÏëÒª2007µÄ¡£ÒòΪÃÜÂ뻹ûÓÐÈËÄÜÆÆ½â³ö
......
ÎÒÓÃAccessµÄʱºò£¬IDÊÇÖ÷¼ü×Ô¶¯Éú³É¡£
ÄDzåÈëÒ»Ìõ¼Ç¼µÄʱºò£¬ÔÚÖ´ÐÐÁ˲åÈëÓï¾äÖ®ºó»¹ÓÐÒ»¸ö´úÂëstring sqlGetId = "select max(Nid) from News" ;
ÊÇÏë»ñÈ¡¸Õ²Å²åÈëµÄ¼Ç¼ËùÉú³ÉµÄID£¬¿ÉÊÇÿ´Î»ñÈ¡µ½µÄ¶¼ÊÇÉÏÒ»Ìõ¼Ç¼µÄID¡£
ÔÚSql ServerÀïȴûÕâ¸öÎÊÌâ°¡£¡
Ŷ£¬Ã»ÊÔ¹ý¡£Ð»Ð»LZ¸æÖ®£¬ÒÔºóÓöµ½ÕâÑùÊÂÇ ......
VB+Access×öµÄϵ統£¬
為·½±ã²é閱與´òÓ¡£¬
Ðè導³ö為execl±í¸ñ£¬
help¡£
環¾³£ºAccess±íÊÇAccess 2000£»
ÍøÉϺܶà,°Ù¶ÈÒ»ÏÂ
¹Ø×¢£¡
´°Ìå´úÂë
VB code:
Private Sub outcstinf_Click() 'µ¼³ö×ÊÁÏΪXLS
Dim i As Integer 'ÐÐ
Dim j As Int ......