topic Access DataBase import results limits in Connectivity & Data Prep

Access DataBase import results limits

Wed, 03 May 2017 09:29:40 GMT

Hi,

I succeded to link my Qlik application with an Acces Dabatase (.accde) through the OLE DB connexion.

The issue is that Qlik only import the 100 (among 10 000) rows of the database. It seems that Qlik does not find the remaining results...

When I open the database with Acces, only the 100 first results appears unless I chose "display all" filter.

I assume that my issue come from this default setting of 100 results displayed but I still don't know how to avoid it.

Would you have an idea ?

Thanks a lot for your help,

Alexis

Re: Access DataBase import results limits

oknotsen — Wed, 03 May 2017 09:59:29 GMT

Are you sure Qlik only loads 100 rows?

Reason I am asking is that it is a common misunderstanding that the preview in the Data Model Viewer shows all data. It does not; it only shows X records (100 sounds about right; I never counted).

Re: Access DataBase import results limits

Wed, 03 May 2017 10:18:54 GMT

You did a strike.

Thank you !

Re: Access DataBase import results limits

oknotsen — Wed, 03 May 2017 12:35:01 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .

Re: Access DataBase import results limits

Thu, 04 May 2017 09:03:08 GMT

Hi Onno,

Finally, I still have an issue with the number of rows imported from the access database. You maybe know how to help.

I've noticed that if I open the Access database and apply filters that reduce the total result to 200 rows (for instance), Qlik only load the 200 rows that are filtered. I tried without filters, qlik loads all the rows (80K+).

How can tell to Qlik "Load all the rows, whatever the filters status"? I assume that it is possible using the script but I could not find how.

Hope it's clear. Thanks a lot.

Alexis