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Èç¹ûÓС°()¡±Õâ¸ö×Ö·ûµÄ»°¾Íµ¼Èëʧ°Ü¡£