Import from Access Database

[#1]

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.

[Nicole-Smith]

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;

[#3 · Accepted solution]

• 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

AJ

[#4]

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