Connect to .accdb

[dhborchardt]

How do you connect to an Access 2010 db. I am guessing you cannot use Jet. If that is the case what Provider do I use. I am wondering if I need to load a driver? I am running Windows 7 64 bit. QlikView 10. I was able to create an ODBC DSN and connect to that.

[#2]

When setting up the connection in the script window, choose ODBC and check the "Force 32 Bit" flag then click Connect. You should get an "MS Access Database" in the Data Sources list (check the "Show User DSNs" flag if necessary). Then select your database and you'll end up having in your script a connection string as below:

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

You can then click on "Select..." and pick your table from the database.

[Miguel_Angel_Baeyens]

Hi,

Office 2010 has irs own native 64 bit driver that will likely improve your data extraction performance. If you don't have the drivers already, download them here

http://www.microsoft.com/download/en/details.aspx?id=13255

Hope that helps.

Miguel

[#4 · Accepted solution]

Hi,

     Please find the attached qvw.

     You have to use Microsoft.ACE.OLEDB.12.0 provider to connect to the .accdb files.

     Hope it helps.

Regards

Rajan

[dhborchardt]

Thanks, this works.

[#6]

Gracias Rajan, me vino barbaro.

[#7]

gr8 stuff!! Was easy to connect reading ur instructions!

Tnx