Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ¼òµ¥Ò×ÓÃ

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


Ïà¹ØÎÊ´ð£º

win7Éϰ²×°sqlserver - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£

ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ


ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾­ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£

SQLSERVER 2000Ã ......

sqlserver saµÇ½ÎÊÌâ¡£ - MS-SQL Server / ÒÉÄÑÎÊÌâ

±¾ÈËÍü¼ÇÁËsaµÄÃÜÂë¡£
ÔÚ¡°°²È«ÐÔ¡±¡ú¡°µÇ¼¡±¡ú¡°saÊôÐÔ¡±¸ü¸ÄÃÜÂëÖ®ºó,ÔÚÖØÐµÇ½¡£
µÇ¼ʧ°Ü¡£
ÓÃwindowsÓû§µÇ½
´úÂë¸ü¸Ä£ºsp_password Null,'123456','sa' »¹ÊÇ
µÇ¼ʧ°Ü¡£
ÔÚ¡°·þÎñ¡±¡ú¡°ÊôÐÔ¡±¡ú¡°µ ......

sqlserverÊý¾Ý¿âµÄ´óС - MS-SQL Server / »ù´¡Àà

ͬÑùµÄÊý¾Ýsqlserver¾­¹ýÊÕËõ£¬Çå¿ÕÈÕÖ¾ ×îºó´óСÊÇ196M
ÆäÖÐÖ»ÓÐÒ»¸ö±íµÄÊý¾Ý¶àһЩ ´óÔ¼42ÍòÌõÊý¾Ý£¬µ¼³ö³ÉÎı¾ºóÊÐ62M
µ«ÎÒ°ÑÕû¸öÊý¾Ý¿âµ¼³öµ½ASAÊý¾Ý¿âºóÊý¾ÝÎļþÊÇ48M£¬ÈÕÖ¾ÎļþÊÇ40M£¬
Ϊʲô»á²î±ðÕâô´ó£ ......

SQLSERVER ×Ö·û´®±í´ïʽ - MS-SQL Server / ÒÉÄÑÎÊÌâ

SQLSERVER ÎÒÓÐÒ»¸ö±í£¬²é³öÀ´µÄÒ»¸ö×Ö¶ÎÊÇ×Ö·û´®±í´ïʽ
±ÈÈç
a b c 5*6-3
a be ce 15*(6-3)
a b c 36-3
a be ce 1*(9-8)
ÎÒÏëÔڴ˺óÃæÔö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ