Export data from SQL server to Excel

Question

Hi All,

while exporting data from SQL server to excel , i was received below error .

please help me on this.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

Thanks in advance!!

Answer 1

Here is a link to a discussion on this same topic:

http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/1d5c04c7-157f-4955-a14b-41d912d50a64

---

Thomas LeBlanc twitter ( @TheSmilingDBA )

Answer 2

And how do you Export the data? With a linked server or Import/Export wizard or ...?

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 3

Hi All,

anyway my issue was resolved by installing below linked DLL files.

https://www.microsoft.com/en-in/download/details.aspx?id=23734

Thanks to all for your prompt response.

Answer 4

Hi Shaik Mastanvali,

Glad to hear that the issue is resolved. Please mark the corresponding replies as answer so It would benefit others when they are reading this thread.

If you have any other questions, please let me know.

Regards,
Lin

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].