Cannot install Microsoft database engine 2016 on a same computer with Office 2019 Professional that was installed from click-to-run installer

Becky D. Fralin 21 Reputation points
2021-08-09T15:47:30.687+00:00

The Office 2019 Pro Plus can be either 32-bit or 64-bit. I am also using Visual Studio 2019 Community and SQL Server Integrations Service Project extension with SSIS package that requires Excel 2016 and Excel 2013 connection managers. The Office Click-to-run was used for the Office 2019 installation and it is the only installation option available to me through our third party vendor. How can I keep Office 2019 and also support SSIS packages which use Excel versions 2013 and 2016 on the same computer?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,589 questions
0 comments No comments
{count} votes

Accepted answer
  1. EchoLiu-MSFT 14,581 Reputation points
    2021-08-10T01:37:35.14+00:00

    Hi @Becky D. Fralin

    Welcome to the microsoft SSIS Q&A forum!

    Sorry, your description is not very clear to me.

    121823-image.png
    Your title mentions 'Cannot install Microsoft database engine 2016'.

    121815-image.png

    But your question is about ‘How can I keep Office 2019 and also support SSIS packages which use Excel versions 2013 and 2016 on the same computer?’

    Can you help explain what problems you actually encountered?

    Notes about the download and installation
    Make sure that you download the Access Database Engine 2016 Redistributable and not the Microsoft Access 2016 Runtime.

    If the computer already has a 32-bit version of Office, then you have to install the 32-bit version of the components. You also have to ensure that you run the SSIS package in 32-bit mode, or run the 32-bit version of the Import and Export Wizard.

    If you have a Microsoft 365 subscription, you may see an error message when you run the installer. The error indicates that you can't install the download side by side with Office click-to-run components. To bypass this error message, run the installation in quiet mode by opening a Command Prompt window and running the .EXE file that you downloaded with the /quiet switch. For example:

    C:\Users\<user_name>\Downloads\AccessDatabaseEngine.exe /quiet

    If you have trouble installing the 2016 redistributable, install the 2010 redistributable instead from here: Microsoft Access Database Engine 2010 Redistributable. (There is no redistributable for Excel 2013.)

    Excel version
    The second piece of info to provide is the version of the Excel file. You provide this info in the Excel Connection Manager Editor in an SSIS package, or on the Choose a Data Source or Choose a Destination page of the Import and Export Wizard.

    Select the version of Microsoft Excel that was used to create the file, or another compatible version. For example, if you had trouble installing the 2016 connectivity components, you can install the 2010 components and select Microsoft Excel 2007-2010 in this list.

    You may not be able to select newer Excel versions in the list if you only have older versions of the connectivity components installed. The Excel version list includes all the versions of Excel supported by SSIS. The presence of items in this list does not indicate that the required connectivity components are installed. For example, Microsoft Excel 2016 appears in the list even if you have not installed the 2016 connectivity components.

    For more detial,please refer to:
    Import data from Excel or export data to Excel with SQL Server Integration Services (SSIS)
    How to run multiple versions of Excel on the same computer

    If you have any question, please feel free to let me know.

    Regards
    Echo


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.