topic Re: Data Gateway ODBC Connection to Excel File in Connectivity & Data Prep

Data Gateway ODBC Connection to Excel File

nhoover — Wed, 01 Nov 2023 17:43:46 GMT

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!

Re: Data Gateway ODBC Connection to Excel File

ajaykakkar93 — Thu, 02 Nov 2023 03:41:15 GMT

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_2010_and_later__xlsx_.htm?TocPath=ARTICLES%7CData%20Sources%7CODBC%20Data%20Sources%7C_____8

Re: Data Gateway ODBC Connection to Excel File

nhoover — Thu, 02 Nov 2023 11:46:39 GMT

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/ODBC-DrectAccess/ODBC.htm

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