Ò»¸öACCESSÊý¾Ý¿â ÄܲåÈ롢ɾ³ý£¬µ«ÊDz»ÄܸüÐÂ
access ÒѽûÓôËÊý¾Ý¿âÖпÉÄÜÓꦵÄÄÚÈÝ vba
ÎÒÓÃaccess´ò¿ªÕâ¸öÊý¾Ý¿âÌáʾ½ûÓÃÁËÕâ¸ö
Èç¹ûÎÒÑ¡ÔñÆôÓà ¾ÍÄܸüÐÂÁË
ÈçºÎÔÚ³ÌÐòÖдò¿ªÊý¾Ý¿âÒ²ÆôÓÃÕâ¸öÄØ£¿
OleDbConnection conn = new OleDbConnection(@"");
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath.ToString() + "\\aar.mdb;Persist Security Info=true";
UP
Äã°Ñ¸üеĴúÂëÌù³öÀ´ Äã¾ÍÌù¸öÁ´½ÓµÄ´úÂë ¿´²»³öÀ´ ÎÒÓÃACCESSµÄʱºò¶¼Õý³£ ÊDz»ÊÇÄãµÄ´úÂëдµÄÓÐÎÊÌ⣡
ûÓùýaccess
²»ÊǺÜÃ÷°×LZµÄÒâ˼¡£¿ÉÒÔ試ÖøÖ±½ÓʹÓÃSQL語¾ä來¸üÐÂ數據¡£Èç¹ûSQL語¾äÄܸüУ¬ÄÇÄã¾Í±Ø須ºÃºÃ檢²éÄãµÄ¸üдú碼ÁË¡£
ɾ³ýÔÙ²åÈë
²»ÊǺÜÃ÷°×£¬°ïÂ¥Ö÷¶¥£¬µÈ¸ßÊÖ½â¾ö£¡
¶àÊÔ¼¸Ì¨»úÆ÷£¬¿´ÊDz»ÊǶ¼ÓÐÕâÑùµÄÎÊÌ⣬Èç¹ûÖ»ÊǸö±ð»úÆ÷³öÏÖÕâÑùµÄÎÊÌ⣬ÄÇ˵Ã÷ÊDzÙ×÷ϵͳµÄÎÊÌ⣬ÄǾͲ»ÒªÈ¥×êÕâ¶«¶«
Ïà¹ØÎÊ´ð£º
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎΪ¡ ......
±ÈÈçÏë°Ñ old¸Ä³É new£¬ÔõÃ´Ð´ÄØ£¿
²»ÄÜ£¬ÓÃADO¡¡OR¡¡DAO
or
select * into new from old
£¬ÓÃADO¡¡Õâ¸öÔõô¸Ä£¿
JET-SQL²»ÄܸıíÃû¡£Ö»ÄÜÉú³ÉÒ»¸öеġ£
Ò»°ãÊÇÖ±½Ó
SQL code:
select * ......
ÔÚ¿Í»§¶ËÓиöaccessÊý¾Ý¿âa.mdb£¬ÀïÃæÓÐÕűítb1£¬Óжþ¸ö×Ö¶ÎÁ÷Ë®ºÅºÍ»ý·Ö
ÔÚ¾ÖÓòÍøÀïÓиö·þÎñÆ÷ipÊÇ192.168.1.88£¬ÔÚ·þÎñÆ÷Àï×°ÁËsql2000£¬ÀïÃæÒ²ÓÐÒ»Õűíaa£¬aa±íÀïÓжþ¸ö×ֶηֱðÊÇb1ºÍb2¡£Êý¾Ý¿âÃûÊÇyy,
......