Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lilinikco
Starting Member
28 Posts |
 Posted - 2011-09-11 : 04:06:27
|
| I am trying to create a linked server within my instance of SQL Server 2008 to an excel 2010 spreadsheet. I have tried using the following code but get the error message EXEC sp_addlinkedserver @server = N'ExcelDataSource', @srvproduct=N'ExcelData', @provider=N'Microsoft.ACE.OLEDB.12.0', @datasrc=N'c:\Temp\oo.xlsx', @provstr=N'EXCEL 12.0' ;error message:OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ExcelDataSource" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".Msg 7399, Level 16, State 1, Line 1The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ExcelDataSource" reported an error. Authentication failed.Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ExcelDataSource".what do i do?please guide me immediatly.thankslili@@ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-11 : 11:49:36
|
| it seems the excel which you're pointing to is currently opened by somebody else. close it and try again------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
create an excel link server in sql server 2008