3

In the Excel Connection Manager, when I choose Excel 97-2003 to connect to an Excel(97-2003) data file as a source, I am able to see the data preview and it works fine, but when I choose Excel 2007 to connect to an Excel 2007 file, it gives the error

Failed to connect to the Excel Connection Manager

What should I do?

Hadi
  • 36,233
  • 13
  • 65
  • 124
A man
  • 31
  • 1
  • 2
  • 1
    Before asking your first question, it is recommended to read the [Tour Page](https://www.stackoverflow.com/Tour) – Hadi Dec 29 '17 at 19:59
  • try installing `Microsoft Access Database Engine 2016 Redistributable`, the issue may be that the excel file version is newer than 2010. Then link is provided in the first naswer – Yahfoufi Jan 02 '18 at 15:14

1 Answers1

0

There are many things to try:

Installing Microsoft Access Database Engine Redistributable

I think that you have to install the Microsoft Access Database Engine Redistributable:

Download Links:

Running project in 32-bit Mode

Go to Project Configuration -> Properties -> Debugging -> Set Run64BitRuntime = False

Similar Issues

The following links contains similar issues, you can refer to one of them:

Hadi
  • 36,233
  • 13
  • 65
  • 124