摘要:
先上SQL:exec sp_configure 'show advanced options',1reconfigureexec sp_configure 'Ad Hoc Distributed Queries',1reconfigureSELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=E:\HaierWeb\MyWeb\Doc\abc.xls;Extended Properties=Excel 8.0')...Sheet1$第一行当做表头。其余 阅读全文
posted @ 2010-03-10 16:34
NewSea
阅读(1839)
评论(0)
推荐(0)

浙公网安备 33010602011771号