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

»ùÓÚ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 ¼òµ¥Ò×ÓÃ

ʹÓù¤¾ß±È½Ï¼òµ¥.


Ïà¹ØÎÊ´ð£º

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......

JDBCÁ¬½ÓSQLServer 2000µÄÎÊÌâ - Java / Web ¿ª·¢

HTTP Status 500 - 
--------------------------------------------------------------------------------
type Exception report
message 
description The server encountered an internal error ......

sqlserverµÄ´æ´¢¹ý³ÌµÄÎÊÌâ - MS-SQL Server / »ù´¡Àà

sqlserverµÄ´æ´¢¹ý³ÌÓÐoracleµÄÄÇÖÖ°üµÄ¸ÅÄîô£¿
¾ÍÊǺܶà¸öÂß¼­ÉÏÓÐÁªÏµµÄ´æ´¢¹ý³ÌÊÇ¿ÉÒÔ·ÅÔÚÒ»¸öpackageÀïÃæµÄ£¿
oracle²»¶®¡£

Ã»Íæ¹ýOµÄ£¬°ï¶¥¡£

ÄÇsqlserver µÄ´æ´¢¹ý³Ì¾ÍÊÇÒ»¸ö¸öµ¥¶ÀµÄÈ«²¿ÁÐÔÚ¡°´æ´¢¹ ......

sqlserver ´¥·¢Æ÷ - MS-SQL Server / »ù´¡Àà

ÓÐÁ½¸ö±íÒ»¸öÊǿͻ§¶©µ¥±í(¶©µ¥ºÅ£¬²úÆ·ºÅ£¬ÊýÁ¿£¬¼Û¸ñ£©,Ò»¸öÊÇÉÌÆ·±í(²úÆ·ºÅ£¬²úÆ·Ãû£¬²úÆ·ÊýÁ¿)
ÈçºÎÓô¥·¢Æ÷Íê³Éµ±²åÈë¿Í»§¶©µ¥±íºó£¬»á×Ô¶¯¸üÐÂÉÌÆ·±íÖеIJúÆ·ÊýÁ¿
Èô²úÆ·ÊýÁ¿²»¹»Ê±±¨´í£¨¿ÉÊä³öÎÄ×Ö±¨´íÐÅÏ¢ ......

sqlserverÑ­»·Éú³ÉÊý¾Ý - MS-SQL Server / »ù´¡Àà

ÏÖÔÚÓÐÒ»¸ö±ítable1£¬Ö»ÓÐÒ»¸ö×ֶΣ¬varchar£¨10£©
num
111
112
113
114
ÏÖÔÚÏëҪѭ»·table1ÖеÄËùÓÐÊý¾Ý£¬Ô­À´µÄ111Éú³É111001-111999²åÈëµ½table2ÖÐ
SQL code:
Select ltrim([num])+right(1000+number,3) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ