This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 52%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
I have an existing SSIS package that wrote data to an excel spreadsheet (Office 2016) We have upgraded to Office 365 and now I am unable to connect to or write to an Excel spreadsheet when trying to configure my SSIS package. It will only work when setting up an excel version of 2007-2010.
And how the the package write to Excel/with which technic?
OleDB wit ACE, script task or ...?
Please provide much more detail about how your package works; we can't guess that.
Hi @Guilfoy, Kristy,
Please try installing Microsoft Access Database Engine 2016 Redistributable, the issue may be that the excel file version is newer than 2010.
Download Links:
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Thank you Zoe. That has resolved my issue.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @Guilfoy, Kristy,
We have upgraded to Office 365 and now I am unable to connect to or write to an Excel spreadsheet when trying to configure my SSIS package.
It is not clear what machine you are referring to.
You need to make sure that you have Microsoft ACE OLEDB Provider version 12.0 and/or 16.0 installed.
