Click here to Skip to main content
15,877,939 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am trying to export table data in excel and end up getting this error.
Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine.

Export in flat file works all good, but failing for excel.

What I have tried:

Tried exporting in all possible Excel versions with appropriate file extensions viz .xls, .xlsx
Posted
Updated 18-Oct-19 0:53am
v2
Comments
Richard MacCutchan 18-Oct-19 4:46am    
The message is clear, what part of it do you not understand?

1 solution

Working with data in Excel or Access requires the appropriate driver be installed:
Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center[^]
 
Share this answer
 

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