Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
nhoover
Luminary
Luminary
‎2023-11-01 01:43 PM

Data Gateway ODBC Connection to Excel File

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!

Labels (1)
Labels
636 Views
0 Likes
2 Replies
ajaykakkar93
Specialist III
Specialist III
‎2023-11-01 11:41 PM

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...

 

ajaykakkar93_0-1698896422670.gif

 

 

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

610 Views
0 Likes
nhoover
Luminary
Luminary
‎2023-11-02 07:46 AM
Author

In response to ajaykakkar93

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.

599 Views