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 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed.
[OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.]
开始的时候老是报错,最后我用DTS导入了一次,在执行sql语句居然就可以了!