Click here to Skip to main content
14,770,737 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.
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

   
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