Excel 2007 to sql 2005 using openrowset

I've been trying to use Microsoft.ACE.OLEDB.12.0 provider unsucessfully.  I get the message:
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.

After doing some searching on the web, based on the various recommendations I've reviewed, I've downloaded the driver from:  http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

I still get the above message.  I guess I haven't "registered" the driver yet.  Is that the problem?

Here's my code:

SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
                'Excel 12.0 Xml;HDR=YES;
                   Database=H:\Excel\Test.xlsx',
                'Select * From [Sheet1$]');



bgernonAsked:
Who is Participating?
 
Vipul PatelConnect With a Mentor .NET ExpertCommented:
If you are using SQL Server of the main server then it will affect main server.
0
 
Vipul Patel.NET ExpertCommented:
Have you executed below queries?

EXEC sp_configure 'show advanced options',1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
0
 
bgernonAuthor Commented:
I'm just now remembering that I used to have a local server on my computer at my last job.  I do not have one on this computer. I hesitate to invoke stored procedures from the main server.   Can you tell me if running these will affect my computer only or the main server?  
0
 
bgernonAuthor Commented:
Let me make sure I understand what you are saying.  Currently, I am using sql server express from my desktop to query a database on a main server.  If I run the stored procedures from my desktop, it will affect the main SQL server?

I  looked up EXEC sp_Configure.  Based on what I am reading, sounds like the system admistrator needs to turn the Ad hoc so that I can use openrowset and Show advanced options on.  I'll speak with the admistrator.  

Thanks
0
 
bgernonAuthor Commented:
Could have used and explaination of what each stored procedure did and who needs to execute them.  I had to look them up on the web.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.