现在出现下列错误,请问我该怎么解决呢?
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message:Cannot start your application.The workgroup information file is missing or opened exclusively by another user]
T-SQl语句
INSERT INTO ERS
(Vendor, Purchasing, Trans, Material_Doc, Item, Posting_da, Quantity,Price, Amount,Curre, Reference, Document, Reference_Doc, Material, Plant)
select * from (SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\book1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]) aa