excelµ¼Èësql server2005µÄÎÊÌâ
[Excel Ô´ [1]] ´íÎó: Êä³ö¡°Excel Ô´Êä³ö¡±(9) É쵀 Êä³öÁС°Description 3¡±(546) ³ö´í¡£·µ»ØµÄÁÐ״̬ÊÇ:¡°Îı¾±»½Ø¶Ï£¬»òÕßÒ»¸ö»ò¶à¸ö×Ö·ûÔÚÄ¿±ê´úÂëÒ³ÖÐûÓÐÆ¥ÅäÏî¡£¡±¡£ ¸ÃÁÐÔÚexcelÖÐ×Ϊ308¸ö×Ö·û£¬µ«ÊÇexcelÔ´ÖеÄÍⲿÁкÍÊä³öÁÐ×î¶àÖ»ÄÜÉèΪNvarchar(255),Èç¹ûÉ趨³¤¶È³¬¹ý255£¬Ôò³öÏÖ¾¯¸æ£¬Ô´ÁÐÊôÐÔ²»Æ¥Å䣬ִÐÐҲͨ²»¹ý¡£Ê¹ÓÃNtextÀàÐÍÒ²³¢ÊÔ¹ý£¬²»Æ¥Åä¡£ ÎÒʹÓÃado.netµ¹ÊǰÑËüµ¹Èëµ½Êý¾Ý¿âÁË£¬µ«ÊÇ·¢ÏÖËùÓг¬¹ý255µÄ¶¼±»½Ø¶ÏÁË¡£ ÎÒÊÔ¹ý°ÑexcelÖиÃÁÐÉèΪÎı¾¸ñʽҲ²»ÐС£ ÕâÖÖ³¤×Ö·ûÁÐÓ¦¸ÃÔõô´¦Àí£¿
ÎÒÏÖÔÚµ¼EXCEL¶¼ÊÇÖ±½ÓÔÚEXCELÖÐÆ´³öINSERTÓï¾ä£¬·½±ãÓÖÁé»îÒýÓà ÎÒÏÖÔÚµ¼EXCEL¶¼ÊÇÖ±½ÓÔÚEXCELÖÐÆ´³öINSERTÓï¾ä£¬·½±ãÓÖÁé»î ÔÚEXCELÖÐÆ´³öINSERTÓï¾ä£¿ÈçºÎ×ö£¬ÇëÖ¸µ¼£¬Ð»Ð»¡£ ÓÃOpenDataSourceÂ𣿠ûÑо¿¹ý ûÑо¿¹ý SQL code: --»òÕß¿½貝µ½Îı¾ÖÐbulk insert bulk insert test from 'E:\Test.txt' with( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) select * from test ÎÒ²»Ï²»¶ÓÃÓï¾ä ÎÒÒ»°ã¶¼Ï°¹ßÓõ¼Èëµ¼³ö¹¤¾ß ×î½ü±»¿Í»§Ò»Ð©ÂÒÆß°ËÔãµÄexcel¸ãµÄ½¹Í·Àö¸ñʽÎޱȻìÂÒ£¬ÓïÑÔÒ²¸úÎÒÃDz»Í¬¡£¡£ÒýÓà SQL code--»òÕß¿½貝µ½Îı¾ÖÐbulk insertbulkinsert testfrom'E:\Test.txt'with( FIELDTERMIN
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï° http://www.hxzi.com/view/61402.html B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿ 21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30 Ö¸µ ......
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÇëÎÊ£º 1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿ 2,ʹÓÃÍøÉÏ´úÂ룺 Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......