How to load .accdb files to Qlik Sense Cloud version?

[bobhopkins]

Good day everyone,

Does anyone know how to load .accdb files in Qlik Sense Cloud? I checked the list of available connectors, but couldn't find which one to use.

[Ayaka_Hanazono · Accepted solution]

Hello @bobhopkins  
You can utilize Qlik DataTransfer to load data from the access data file.

First, you need to install the driver and set up an ODBC connection.

Qlik DataTrasfer generates a source file, QVD file from the .accdb, and your tenant will load data from this QVD.

Please refer to our help pages for more details:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataSource/ODBC.htm

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/QlikDataTransfer/qlik-da...

I hope it helps.

[bobhopkins]

HI Ayaka,

Thank you for the information. How do I access Qlik DataTransfer? Is it a utility that I need to download and install on my local PC?

[Ayaka_Hanazono]

Hi @bobhopkins  You can find the installation package on our product download site or your tenant hub:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/QlikDataTransfer/install...

You can install it on your machine for testing purposes; only server platforms are supported for production.

https://help.qlik.com/en-US/sense-admin/May2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployA...