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

[MogilevskyO]

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

[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)?

[MogilevskyO]

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

[MogilevskyO]

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?

[MogilevskyO]

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?