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 |
|
LearningSQL2
Starting Member
10 Posts |
 Posted - 2011-07-20 : 12:47:25
|
| -------------------------------------------------------------------------------- Hello,I am a first-time SQL user (And new to this forum) trying to learn how to make several spreadsheets on Excel export their data to a table on SQL via a server. I currently am using the free 32-bit MS SQL server and the 2007 edition of Excel. I set up the linked server, but when I try to access the Excel table, I get this message:"TITLE: Microsoft SQL Server Management Studio------------------------------Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "JULY13TEST3" reported an error. Access denied.Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "JULY13TEST3". (Microsoft SQL Server, Error: 7399)"Any help and/or guidance would be very much appreciated.Thanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-20 : 14:00:11
|
| Make sure no one, yourself included, has the spreadsheet open. |
 |
|
|
LearningSQL2
Starting Member
10 Posts |
Posted - 2011-07-20 : 17:37:04
|
| Thanks Russell,I'll re-try with the spreadsheet closed. |
|
|
|
|
|
|
Exporting Excel spreadsheets to SQL