导航

Sql 查xls语句

Posted on 2009-08-18 17:37  DotNet1010  阅读(172)  评论(0)    收藏  举报
SELECT * into T_Temptable
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
  'Data Source=d:\allitems.xls;Extended Properties=Excel 8.0')...[allitems$]