delphiµ¼Èëexcelµ½sqlserverµÄsqlÓï¾äÎÊÌâ
'Select * into '+TempTableName+' from OpenDataSource(''Microsoft.JET.OLEDB.4.0'',''Data Source=' +ExcelFilePath+';Mode=Read;Extended Properties=Excel 5.0;Persist Security Info=True'')...[' +SheetName+'$]'; Èç¹ûÎÒµÄexcel±íÖеÄsheetname´øÓС°£¨£©¡±£¨±ÈÈçsheetnameÊÇ£º¼Û¸ñ£¨Ïêϸ£©£©Õâ¸öµÄ»°£¬Õâ¾äÓï¾ä¾Í»á±¨´í¡£ ÔÚÎÒ²»ÐÞ¸ÄsheetnameµÄǰÌáÏ£¬ÎÒÔõôÈÃÕâ¸ösqlÓï¾ä²»±¨´í£¬ÄÜÕýÈ·Ö´ÐÐÄØ£¿
'SELECT * into '+TempTableName+' from openrowset(''MICROSOFT.JET.OLEDB.4.0'', ''Excel 5.0;HDR=YES;DATABASE='+ExcelFilePath+''',''select * from ['+SheetName+'$]'')'; ѧϰÒýÓà 'Select * into '+TempTableName+' from OpenDataSource(''Microsoft.JET.OLEDB.4.0'',''Data Source=' +ExcelFilePath+';Mode=Read;Extended Properties=Excel 5.0;Persist Security Info=True'')...[' +SheetName+'$]'; Èç¹ûÎÒµÄexcel±íÖеÄsheetname´øÓС°£¨£©¡±£¨±ÈÈçsheetnameÊÇ£º¼Û¸ñ£¨Ïêϸ£©£©Õâ¸öµÄ»°£¬Õâ¾äÓï¾ä¾Í»á±¨´í¡£ ÔÚÎÒ²»ÐÞ¸ÄsheetnameµÄǰÌáÏ£¬ÎÒÔõôÈÃÕâ¸ösqlÓï¾ä²»±¨´í£¬ÄÜÕýÈ·Ö´ÐÐÄØ£¿ ´ó¸ç£¬ÎÒµÄÎÊÌâ²»ÊDz»»áµ¼È룬Êǵ¼ÈëµÄʱºòsheetnameÈç¹ûÓС°()¡±Õâ¸ö×Ö·ûµÄ»°¾Íµ¼Èëʧ°Ü¡£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö ÀýÈç procedure produce_proc @p001 nvarchar(8000), @p002 nvarchar(8000), @p003 nvarchar(8000), & ......
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿ ʲôÒâ˼£¿ ¿ÉÒ﵀ 10¸ö¶¼Ã»ÎÊÌâ ¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿ ......