Qlik Community

Ask a Question

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
MogilevskyO
Contributor II
Contributor II

How to download data from source file .mdb (Access) ?

How to download data from source file .mdb (Access) ?

Labels (1)
7 Replies
Anil_Babu_Samineni

What do you mean by download? You want to build up button and when you hit that you want to download .MDB file? and also, are you expecting this in SaaS tenant or on-premise (Because, I see your post under SaaS - based on your input I will move into correct place on this ticket)?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MogilevskyO
Contributor II
Contributor II
Author

Hi Anil,

Thank you for the answer. I just want to use data from .mdb file as normally use data from ExCel file in Qlik.

Can Qlik download data from .mdb like directly or it must be transfer to ExCel format?

Do appreciate your reply.

Best regards,

Oleg

Anil_Babu_Samineni

Not required to convert into Excel files this case. You can use OLEDB connector for MS Access like image below

Anil_Babu_Samineni_0-1614510674151.png

 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MogilevskyO
Contributor II
Contributor II
Author

Hi Anil,

It was so. That was a solution in the past. Now this format of file is not supported (screenshot is attached). There is now chance to open a menu you mentioned. Could you please advice, how to find a solution to download . mdb file? Thank you so much. Have a great week.

Anil_Babu_Samineni

Sorry, can you please convert the error message in english?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MogilevskyO
Contributor II
Contributor II
Author

Sorry, it means "This format is not supported to download"

Anil_Babu_Samineni

CAn you please check once If you able to load Access DB via excel web file and see if you were able to?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)