Skip to content


Excel Data Source Not working 2016

Bill Brennan asked 3 years ago
We have been saving Excel sheets to CSV’s ad using the Text data source successfully for quite some time. Recently I tried to just connect to an xls file, and even though it’s closed, it will not connect to reveal the sheet.
Any ideas appreciated
Ethan Sorenson Staff answered 3 years ago
When connecting to Excel you need the correct Excel driver installed. The one that works the best for me is this one.
Make sure you install the 32-bit version of the driver, because SmartConnect is a 32-bit application.

If you would like to submit an answer or comment, please sign in to the eOne portal.