»ùÓÚsqlserver 2005µ¼³öÊý¾Ýµ½office 2007 Excel
´úÂ룺 insert into openrowset('microsoft.ace.oledb.12.0','excel 12.0;hdr=yes;database=d:\a.xslx','select * from [sheet1$]') select * from table ×¢Ò⣺µ¼³öµÄÊý¾ÝºÍ±íÍ·ÒªÒ»Ö¡£ ÎÊÌ⣺ Èç¹û°´ÕÕÕâ¸ö×ö·¨½øÐе¼³öÊý¾Ý£¬Ôòµ¼³öµÄÊý¾ÝÔòÈ«²¿ÎªÎı¾ÐÎʽ£¬¶øÇÒÊý×ÖÒ²ÊÇÎı¾ÐÎʽµÄ£¨Êý×ÖÈç¹ûΪÎı¾ÐÎʽµÄ»°Ôò²»ÄÜ×öÊý¾Ý͸ÊÓ±í£©£¬Ò²³¢ÊÔ¹ýÐÞ¸Ä×¢²á±í£¬µ«»¹ÊDz»ÉúЧ£¬ÇëÇó¸÷λÀÏ´ó°ïÖú£¡
ÓÃssis°É£¬ Ä¿±êÓãºMicrosoft Office 12.0 Access Database Engine OLE DB Provider SQL code: ÓÃsql×Ô´øµÄµ¼Èë\µ¼³ö dts ¼òµ¥Ò×Óà (1)SSIS (2)BCP µ¼³öµ½office 2003ûÎÊÌâ,office 2007ºÃÏóÓÐÎÊÌâ,°ï¶¥. лл¸÷룬ÎÒÒѾÕÒµ½½â¾ö·½°¸£¬²»¹Ü¶àÉÙÊý¾Ýµ¼³ö¶¼¿ÉÒÔ¿ìËÙÉú³Éexcel¡£ ´ÓsqlÖ±½Óµ¼³öµÄÊý¾ÝĬÈÏÊÇÎı¾¸ñʽµÄ£¬excelÔÚ°²×°µÄʱºò×¢²á±íÀïÃæÄ¬ÈÏ»á¶Ôǰ8ÐÐÊý¾Ý½øÐÐÑéÖ¤À´È·ÈÏÄÇÒ»ÁÐÓ¦¸ÃÊÇÎı¾»¹ÊÇÊý×Ö£¬ËùÒÔÎÒÃÇÔÚµ¼³öµÄʱºòÊ×ÏÈÒªÉú³ÉÒ»¸öexcelÎļþ£¬²¢ÇÒÓÐÊý¾ÝÔÚÀïÃæ£¬È»ºóÔÙ½øÐÐÖ´ÐдÓsqlÖе¼³ö¡£ÒýÓà dts ¼òµ¥Ò×Óà ʹÓù¤¾ß±È½Ï¼òµ¥.
Ïà¹ØÎÊ´ð£º
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£ 2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ ) ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
HTTP Status 500 - -------------------------------------------------------------------------------- type Exception report message description The server encountered an internal error ......
sqlserverµÄ´æ´¢¹ý³ÌÓÐoracleµÄÄÇÖÖ°üµÄ¸ÅÄîô£¿ ¾ÍÊǺܶà¸öÂß¼ÉÏÓÐÁªÏµµÄ´æ´¢¹ý³ÌÊÇ¿ÉÒÔ·ÅÔÚÒ»¸öpackageÀïÃæµÄ£¿ oracle²»¶®¡£ Ã»Íæ¹ýOµÄ£¬°ï¶¥¡£ ÄÇsqlserver µÄ´æ´¢¹ý³Ì¾ÍÊÇÒ»¸ö¸öµ¥¶ÀµÄÈ«²¿ÁÐÔÚ¡°´æ´¢¹ ......
ÓÐÁ½¸ö±íÒ»¸öÊǿͻ§¶©µ¥±í(¶©µ¥ºÅ£¬²úÆ·ºÅ£¬ÊýÁ¿£¬¼Û¸ñ£©,Ò»¸öÊÇÉÌÆ·±í(²úÆ·ºÅ£¬²úÆ·Ãû£¬²úÆ·ÊýÁ¿) ÈçºÎÓô¥·¢Æ÷Íê³Éµ±²åÈë¿Í»§¶©µ¥±íºó£¬»á×Ô¶¯¸üÐÂÉÌÆ·±íÖеIJúÆ·ÊýÁ¿ Èô²úÆ·ÊýÁ¿²»¹»Ê±±¨´í£¨¿ÉÊä³öÎÄ×Ö±¨´íÐÅÏ¢ ......
ÏÖÔÚÓÐÒ»¸ö±ítable1£¬Ö»ÓÐÒ»¸ö×ֶΣ¬varchar£¨10£© num 111 112 113 114 ÏÖÔÚÏëҪѻ·table1ÖеÄËùÓÐÊý¾Ý£¬ÔÀ´µÄ111Éú³É111001-111999²åÈëµ½table2ÖÐ SQL code: Select ltrim([num])+right(1000+number,3) ......