Click here to Skip to main content
15,885,823 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,
I am using sql server i want impoet and export data in excel sheet,
my system comfigration sql server 2008 and office 2007.

eg.
SQL
SELECT *
FROM   OPENROWSET('Microsoft.ACE.OLEDB.12.0',
       'Excel 12.0 Xml;HDR=YES;Database=C:\Users\prasadr\Desktop\Import And Export\LinkHub.xlsx',
       'SELECT * FROM [Employees$]')


i try this but these error occure:
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.

how to solve this error.
Posted
Comments
Tomas Takac 12-Nov-14 4:21am    
Did you check the provider is installed?
Shweta N Mishra 12-Nov-14 4:24am    
you need to register that provider in your DB server.

1 solution

 
Share this answer
 
Comments
Member 10219739 14-Nov-14 1:01am    
This error Solve The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.
but at the time this error occure OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
plz tell me how to solve these error.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900