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

winformµ¼Èëexcelµ½accessÊý¾Ý¿âÖÐ

        ÏîÄ¿ÖÐÓõ½Á˴˹¦ÄÜ¡£°Ñ´ó¸Å×ö·¨¸ú´ó¼Ò¹²ÏíÏ£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£Ò²¸ø×Ô¼º×ܽáһϣ¬¼¤Àø×Ô¼ºÔÙ½ÓÔÙÀ÷¡£ÏÂÃæÖв¿·Ö´úÂë±»ºº×ÖÌæ»»ÁË£¬Ö÷Òª¿¼Âǵ½¹«Ë¾µÄ²úƷȨ£¬Ï£ÍûÁ½⡣
        /// <summary>
        /// µã»÷´ò¿ª°´Å¥
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnOpen_Click(object sender, EventArgs e)
        {
            try
            {
                OpenFileDialog ofd = new OpenFileDialog();
                ofd.Filter = "ExcelÎļþ(*.xls)|*.xls";
                //±êÌâ
                ofd.Title = "´ò¿ª";
                //¶àÑ¡
                ofd.Multiselect = false;
                //ĬÈÏÖµ
                ofd.FilterIndex = 1;
                ofd.InitialDirectory = System.AppDomain.CurrentDomain.BaseDirectory;
            &


Ïà¹ØÎĵµ£º

Access 2007µÄʹÓ÷½·¨

  ±¾À´¿¼ÂÇÓÃXMLÎļþÀ´´æÊý¾ÝÊÇÒòΪÆä¿çƽ̨ÐÔ£¬¶øÇÒ²»Óð²×°Ìض¨µÄÈí¼þ¡£µ«¾­¹ýÑо¿ÁËÒ»Õó×Ó·¢ÏÖ£¬XMLÓÃÓÚ´æ·ÅÉÙÊý¾ÝÊÇ¿ÉÒÔ£¬µ«´æ·Å´óÖÐÐÍÊý¾Ý¾ÍÏԵúܳÔÁ¦£¬»³ÒÉҲûÓÐÈË»áÕâô×ö¡£¶øÈç¹û²ÉÓÃSQL SERVER´æÊý¾Ý£¬ÓÖÏԵñȽÏÇü²Å£¬±Ï¾¹ÎÒ×öµÄÖ»ÊÇÑо¿¿Í»§¶ËµÄÒ»¸öС³ÌÐò£¬ÅäÖôú¼ÛҲ̫´óÁË¡£»ùÓÚÕâÁ½ÕßÖ®¼ä£¬»¹ÊǾö¶¨Ñ ......

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

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

[Òý]SQLServerºÍAccess¡¢ExcelÊý¾Ý´«Êä¼òµ¥×ܽá

http://www.tongyi.net/article/20031101/200311013786.shtml
ËùνµÄÊý¾Ý´«Ê䣬ÆäʵÊÇÖ¸SQLServer·ÃÎÊAccess¡¢Excel¼äµÄÊý¾Ý¡£
ΪʲôҪ¿¼Âǵ½Õâ¸öÎÊÌâÄØ£¿
ÓÉÓÚÀúÊ·µÄÔ­Òò£¬¿Í»§ÒÔǰµÄÊý¾ÝºÜ¶à¶¼ÊÇÔÚ´æÈëÔÚÎı¾Êý¾Ý¿âÖУ¬ÈçAcess¡¢Excel¡¢Foxpro¡£ÏÖÔÚϵͳÉý¼¶¼°Êý¾Ý¿â·þÎñÆ÷ÈçSQLServer¡¢ORACLEºó£¬¾­³£ÐèÒª·ÃÎÊÎı¾Êý ......

C#¹Ø¼ü×Ö£º·ÃÎʹؼü×Ö£¨access keyword£©

 C#ÖзÃÎʹؼü×Ö£¨access keyword£©ÓÐÁ½¸ö£ºbase¡¢this
 
1.base
   ÓÃÓÚ´ÓÅÉÉúÀàÖзÃÎÊ»ùÀàµÄ³ÉÔ±£¬°üÀ¨£º
     a.µ÷ÓûùÀàÉÏÒѱ»ÆäËü·½·¨ÖØÐ´£¨override£©µÄ·½·¨¡£
     b.Ö¸¶¨´´½¨ÅÉÉúÀàʵÀýʱӦµ÷ÓõĻùÀ๹Ô캯Êý¡£
  ×¢Ò⣺¶Ô»ùÀàµÄ·ÃÎÊÖ»ÄÜ ......

Access ´íÁË£¬»¹ÊÇÎÒɵÁË

×î½üϵͳÔËÐÐÖз¢ÏÖAccess 2003 °æ±¾ÖжԴý Null ºÍ ‘’ £¨¿Õ×Ö·û£©Ææ¹ÖÎÊÌâ£¬ÖØÏÖ²½Ö裺
1¡¢´´½¨±ítabTest £»
2¡¢Ê¹ÓÃÉè¼ÆÊÓͼÌí¼ÓÁ½¸ö×Ö¶Î ID £¬col1
Ãû³Æ
ÀàÐÍ
³¤¶È
˵Ã÷
ID
Number
 
 
Ö÷¼ü£¬×ÔÔö
Col1
char
1
ÎÞ
 
3¡¢Ê¹ÓÃsql Ìí¼ÓÈçÏÂÊý¾Ý
-- col1 ×Ö¶ÎÉèÖÃΪ null
INS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ