topic Re: How to download data from source file .mdb (Access) ? in Management & Governance

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

MogilevskyO — Fri, 02 Apr 2021 08:51:37 GMT

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

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

Anil_Babu_Samineni — Sat, 27 Feb 2021 19:30:59 GMT

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

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

MogilevskyO — Sun, 28 Feb 2021 04:12:25 GMT

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

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

Anil_Babu_Samineni — Sun, 28 Feb 2021 11:11:22 GMT

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

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

MogilevskyO — Mon, 01 Mar 2021 05:39:02 GMT

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.

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

Anil_Babu_Samineni — Mon, 01 Mar 2021 08:01:47 GMT

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

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

MogilevskyO — Mon, 01 Mar 2021 08:12:02 GMT

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

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

Anil_Babu_Samineni — Wed, 03 Mar 2021 20:43:14 GMT

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