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

½â¾öSQL ServerתACCESS×Ô¶¯±àºÅÎÊÌâ


1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍΪ“Microsoft Access¡£µã “ÎļþÃû(F)” ºóÃæµÄ°´Å¥Ñ¡ÔñÄ¿±ê.MDBÎļþ¡£
4.Ñ¡Ôñ“´ÓÊý¾Ý¿â¸´ÖƱíºÍÊÓͼ”¡£
5.ÎÒÃÇ×¢ÒâÕâÀïÑ¡±íµÄʱºòÓÒ±ßÓÐÒ»¸ö“ת»»”ÁС£SQLµ¼³öֻת»»Êý¾ÝÀàÐͲ¢²»¿¼ÂÇÆäËû½Å±¾ËùÒÔÎÒÃÇÓöµ½µÄ×Ô¶¯±àºÅÎÊÌâÒ²¾Í³öÔÚÕâÀï¡£ÓÐ×Ô¶¯±àºÅµÄÒ»¶¨ÒªµãÑ¡“ת»»”¡£
6.ÎÒÃǻؿ´µ½Ò»¸ö“ÁÐÓ³ÉäºÍת»»”¶Ô»°¿ò¡£ÓÐ×¢Òâµ½×ÔÔöµÄemployeeid int ×ÔÔöÕâÀï±ä³ÉÁËAccessÀïµÄlongÕâ¿Ï¶¨²»¶Ô£¬long²¢²»ÊÇ×Ô¶¯±àºÅ£¬Ö»ºÃÐ޸Ľ¨±í½Å±¾£¬Í¼Æ¬ÉÏÄǸöºìȦÀïµÄ°´Å¥“±à¼­SQL”¡£
¿ªÒ»¸öС´°create talbe
ºìȦÖеĽű¾¾ÍÊÇemployeeid µÄ Access½¨±í½Å±¾£¬ÔÚ “NOT NULL” Ç°Ãæ¼ÓÉÏ “IDENTITY (1, 1)”¡£
7.Á¢¼´Ö´ÐС£
ÏÂͼ±íʾ½¨±í¸´ÖÆÒѳɹ¦
8.ÎÒÃÇ´ò¿ªMDBÎļþ¿´¿´ÊDz»ÊÇÈçÎÒÃÇËùÔ¸£¿
OKÍê³É£¬¹§Ï²Äã²Ù×÷³É¹¦


Ïà¹ØÎĵµ£º

½«accessµ¼ÈëSQL server

Ò»¡¢SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡¡ð1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡¡ð2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºóÑ¡Ôñ  czdImport Dat ......

SQL SERVER ÓëACCESS¡¢EXCELµÄÊý¾Ýת»»

ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØʵÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......

Access ÀàÐÍת»»º¯Êý

 Ç°ÑÔ
    ×î½üÒ»Ö±ÔÚ×öAccessÊý¾Ýµ¼ÈëOracleµÄÒ»¸ö³ÌÐò£¬¾¡¹ÜÏîÄ¿ÒѾ­Íê³É£¬µ«ÊÇÓÐʱҲ»áÓöµ½ÎÊÌ⣬×îÖ÷Òª»¹ÊǶÔAccess²»ÊìϤµÄÔ­Òò£¬ÌرðÊÇÀàÐÍת»»£¬¶øÕâ¸öÊÇÎÒÕâ¸öÏîÄ¿ÖÐÒ»¶¨»áÓöµ½µÄ¡£ËùÒÔ¿´µ½ÕâÑùһƪÎÄÕÂͦºÃµÄ£¬¾Íת¹ýÀ´ÁË¡£
תÌùµØÖ·£ºhttp://www.cnblogs.com/wf225/archive/2008/10/09/130 ......

AccessÊý¾Ý²Ù×÷Update·½·¨

using System.Data.OleDb; //ÕâÀïÒªÒýÓÃOleDb¿Õ¼ä
public partial class addInfo : System.Web.UI.Page
{
    //Êý¾Ý¿âÁ¬½Ó×Ö·û´®
    static string strCon = @"provider = Microsoft.Jet.OLEDB.4.0;Data source = |DataDirectory|gyMDB.mdb";
    //ÒÔÉÏ·½·¨ÎªÁ¬½ÓACC ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ