topic Connect to .accdb in QlikView

Connect to .accdb

dhborchardt — Fri, 13 Jan 2012 19:44:13 GMT

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.

Connect to .accdb

Fri, 13 Jan 2012 21:28:37 GMT

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.

Connect to .accdb

Miguel_Angel_Baeyens — Fri, 13 Jan 2012 21:33:08 GMT

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

Re: Connect to .accdb

Sat, 14 Jan 2012 07:35:17 GMT

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

Connect to .accdb

dhborchardt — Tue, 17 Jan 2012 19:10:55 GMT

Thanks, this works.

Connect to .accdb

Tue, 31 Jan 2012 02:44:29 GMT

Gracias Rajan, me vino barbaro.

Re: Connect to .accdb

Tue, 02 Oct 2012 18:56:00 GMT

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

Tnx