Data Gateway ODBC Connection to Excel File

[nhoover]

I'm having trouble setting up the configuration for importing an Excel file via ODBC using a data gateway. Can anyone provide guidance or share screenshots of a successful setup to create a view of the file? I've already submitted a support ticket, but they also recommended seeking help from this group. Your assistance would be greatly appreciated!

[ajaykakkar93]

Hi,

Have you tried updating the driver for ODBC?

Download: https://www.microsoft.com/en-us/download/details.aspx?id=54920

Link: https://help.loftware.com/lps-kb/content/data%20sources/how_to__install_32_bit_odbc_driver_for_excel...

[nhoover]

Love the movie walkthrough @ajaykakkar93 ! I have the latest driver installed and am using Qlik Sense Cloud SaaS via a Data Gateway for the ODBC connection. It's a new feature and looks a bit different than what you posted. It has to be 64-bit, and also a System DSN only.
https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/OD...

Thanks again for the reply! My search is still ongoing.