Share via

How to fix - Excel Connection Manager fails in SSIS

Martin, Daniel 30 Reputation points
2023-05-09T02:44:51.95+00:00

Hi there! I am trying to ingest data from an Excel file (.xlsx) using SQL Server Integration Services (SSIS) through Visual Studio. The versions/specs that I am running are:

  1. Microsoft Visual Studio 2022 - 64 bit version 4.8.04084
    1. SQL Server Data Tools - 17.2.40120.0
    2. SQL Server Integration Services - 16.0.5209.0
  2. Microsoft 365 Apps for enterprise - 16.0.15601.20626
    1. Excel file (xlsx) shows that I have the 32-bit version.

The error I am getting is:

TITLE: Microsoft Visual Studio

Could not retrieve the table information for the connection manager 'Excel Connection Manager'.

Failed to connect to the source using the connection manager 'Excel Connection Manager'

BUTTONS:

OK

I've tried multiple things from this forum and Stackoverflow but cannot seem to resolve the issue. Any help would be greatly appreciated!

Thank you in advance

Dan

SQL Server Integration Services
0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Corey Yang 0 Reputation points
    2025-07-28T07:57:10.1533333+00:00

    Try to install 32 bit Microsoft Access Database Engine 2016 then 64 bit. It works in VS2022.

    AccessDatabaseEngine.exe /quiet

    AccessDatabaseEngine_X64.exe /quiet

    0 comments

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.