topic Re: Import from Access Database in QlikView

Import from Access Database

Mon, 10 Mar 2014 18:53:29 GMT

I'm very new to Qlikview and was asked to find out how to import data from a Microsoft Access table into Qlikview. Is this even possible? I haven't found a solution online. If it is possible, how is it done? Thanks.

Re: Import from Access Database

Nicole-Smith — Mon, 10 Mar 2014 19:05:18 GMT

Your connection string should look something like the following, then you can just use select statements to pull in data from your table:

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\USERS\TEST\Desktop\AccessDatabase.mdb];

SELECT * FROM YourTable;

Re: Import from Access Database

Mon, 10 Mar 2014 20:13:44 GMT

Go to edit page
Check 'Force 32 bit'
Database as ODBC
Click connect and check 'Show user DSNs'. You will see MS Access database. Click it and browse to your file and click it
The connection string mentioned by Nicole would get pasted in your page
Then select 'Select' and pick your tables of interest

Thanks

Re: Import from Access Database

Tue, 11 Mar 2014 11:14:20 GMT

Thank you both Nicole and AJ! Very helpful and perfect. It worked like a charm!!!!!