sql server2000 直接读取excel2003文件的sheet
摘要:
SELECT top 100 * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="f:\zhougang\cr.xls";Extended properties=Excel 5.0')...[sheet1$]开始报错说Server: Msg 7399, Level 16, State 1, Line 1OLE DB prov... 阅读全文