é¦å
éè¦ç¥éæ¯å¯¼åºåªä¸ªä¸ä¸ªæ°æ®åºçæ°æ®ã使ç¨SQL Server Management Studioè¿æ¥ä¸è¿ä¸ªæ°æ®åºã
2
ç¶åç¡®å®éè¦å¯¼åºåªä¸ªè¡¨çæ°æ®ä¸ºExcelæ件ãè¥è¡¨ç项ç®å¾å¤ï¼å¯ä»¥å³é®â表âçéæ¡ä»¶ã
3
è¥ç¥éæ¯åªä¸ä¸ªæ°æ®åºåªä¸ä¸ªè¡¨ï¼ååé¢ä¸¤ä¸ªæ¥éª¤å¯ä»¥çç¥ï¼ç´æ¥æ°å»ºæ¥è¯¢ï¼ä½¿ç¨çSQLå½ä»¤æ¥è¯¢è¿ä¸ªè¡¨ã并å¯ä»¥å ä¸æ¡ä»¶è¯å¥ã
4
å¨æ¥è¯¢åºæ¥çç»æä¸ï¼ç¹å»æå·¦ä¸è§å³é®å
¨éï¼éä¸åï¼åç¹å»å³é®ï¼éæ©âå°ç»æå¦å为âãåæ ·è¥éæ©å¤å¶ï¼ç¶ååæå¼ä¸ä¸ªç©ºç½çEXCELç²è´´è¿å»ä¹å¯ä»¥ï¼éåå°éæ°æ®ã
5
ä¿åç±»å为CSVæ ¼å¼ï¼æ¤ç±»åçæ件å¯ä»¥ç´æ¥ä½¿ç¨çEXCELæå¼ï¼å¹¶ä¿æåä¸è¡ä¸åã
6
å°ä¿åçç»ææå¼åä¸SQLä¸çç»æä¸è´ï¼åæ ·å¯ä»¥é¨åéæ©å¤å¶ï¼ç¶åç²è´´å°ç©ºç½çEXCElä¸ã
END
导åºå®æ´çSQLæ°æ®è¡¨ä¸ºExcelæ件
è¥æ¯æ°æ®è¡¨ä¸çæ°æ®éå¾åºå¤§ï¼åå¯ä»¥ä½¿ç¨SQL Server Management Studioèªå¸¦ç导åºåè½ãå¦å¾æ°æ®åºå³é®-ä»»å¡-导åºæ°æ®ã
è¾å
¥SQL Serverç身份éªè¯ã注æç¡®å®æ¯å¯¼åºåªä¸ä¸ªæ°æ®åºä¸çæ°æ®è¡¨ãç¹å»ä¸ä¸æ¥ã
éæ©å¯¼åºç®æ 为Microsoft Excelæ件ã
éæ©å¯¼åºçEXCELæ件ä¿åè·¯å¾åæ件ååã继ç»ä¸ä¸æ¥ã
è¿ééè¦æ³¨æéæ©çæ¯Excelççæ¬ï¼è¥éæ©äºä½çæ¬çOfficeå导åºçæ°æ®æ¡æ°å°ä¼æéå¶ã
注æï¼è¥æ¯æ´ä¸ªSQLæ°æ®è¡¨å¯¼åºéæ©ç¬¬ä¸é¡¹ï¼è¥æ¯éè¦ç¼åæ¥è¯¢æå®æ°æ®ï¼å¯ä»¥å¨éæ©äºé¡¹ãç¶åè¾å
¥å½ä»¤å³å¯ã
éæ©éè¦å¯¼åºçæ°æ®è¡¨ï¼æ³¨æï¼è¿éå¯ä»¥éæ©å¤ä¸ªè¡¨ä¸èµ·å¯¼åºã
导åºæåï¼å¯ä»¥æ¥çä¼ è¾çè¡æ°ï¼æ³¨æè¥æ¯Officeä½çæ¬ï¼è¡æ°ä¸æ¯æè¶
è¿65535è¡ã
å°å¯¼åºçè·¯å¾ç®å½ä¸æå¼å¯¼åºçExcelæ件ï¼å¯ä»¥çå°ææå¦å¾æ示ãå¦ææ°æ®éå¾åºå¤§å»ºè®®å¯¼åºä¿åçæ ¼å¼ä¸è¦éæ©EXCElæä»¶æ ¼å¼ã
åèèµæï¼
http://jingyan.baidu.com/article/fedf0737a8064b35ac8977c5.html