Set the provider argument and Extended Properties as follows:
Provider=Microsoft.ACE.OLEDB.12.0
Extended Properties=Excel 12.0
It will be work fine.
Provider=Microsoft.ACE.OLEDB.12.0
Extended Properties=Excel 12.0
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.
Venkat MungariPosted May 15, 2015, 6:16 AM
in my local machine it working but in server it is not working, i unable to install "AccessDatabaseEngine.exe" in server is there any other solutions.