If you create an odbc or oledb connection to the access database you can use the access sql to get the data.
select * from sometable where a = 'A';
The sql statement is not parsed (or even understood) by qlikview, but handed as a string to the database engine. The database engine returns the results to qlikview. So you can use the same sql you use in access in your qlikview load script.
Exactly, but what we want to do is to totally be independent from Access. We want to have the functionality in Qlikview.
Background is that this Access-Tool does an Analysis for customers and now one customer asks to do this analysis on his own. But because we dont want to send him the Access-DB (there is a lot of knowledge and algorithm in it) we want to create a Qlikview tool for that which we can save better.
So I need the Select-Statements as a QV-Script.