multiple access database sources

[#1]

Hi everyone,

I have one question

Can Qlikview reports from multiple access database sources like SQL. Actually I have access database which contains data upto March. Now I have another access database which contains data from March to further in future. I have one qvw filw which contains data up to March. now as per user request I need to make the qvw file as archive and I need to create another file same as previous but the data needs to be from March to future. Will it be possible to have two datasources in one  qvw file what I mean is

ODBC connect to C:\Qlikview\Sources\access\ access1(contains only data upto March)

ODBC connect to C:\Qlikview\Sources\access\ access2(contains data from March to further in future)

can anyone clarify my doubt.

Thanks.

[Gysbert_Wassenaar · Accepted solution]

Yes that's possible. Just be sure to load the all data you need from the first database before connecting to the second database.

[#3]

Thanks for this.