山丘哥哥

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语句居然就可以了!

posted on 2009-08-28 18:15  科比*布莱恩T  阅读(454)  评论(2编辑  收藏  举报