topic connect to Access 2010 in QlikView

connect to Access 2010

Wed, 30 Nov 2011 14:36:57 GMT

anyone know how to connect to Access 2010?

I can only connect to *.mdb files not *.accdb.

connect to Access 2010

SunilChauhan — Wed, 30 Nov 2011 14:43:11 GMT

press control +E -> in edit script -> click on connect-> MS access database in dialogue ->finish

now click on select-> select your table and reload

connect to Access 2010

Wed, 30 Nov 2011 14:53:45 GMT

it keeps asking me for login authorization. it's my own personel database. i don't have a login.

i hit ok to bybass login and qlikview takes me back to database dialogue screen.

only .mdb file name i can connect too. why not .accdb?

connect to Access 2010

SunilChauhan — Wed, 30 Nov 2011 14:57:36 GMT

then you need to provide user name and password for that,because here i am able to connect without password.

connect to Access 2010

SunilChauhan — Wed, 30 Nov 2011 14:59:33 GMT

give you file path and file name and try again with this one

ODBC CONNECT TO [MS Access Database;DBQ=C:\DOCUMENTS AND SETTINGS\SKCHAUHAN\DESKTOP\sunil\pmbr.mdb];

LOAD *;

SQL SELECT *

FROM pmbr1;

hope this helps

connect to Access 2010

Wed, 30 Nov 2011 15:04:07 GMT

that's a .mdb access db.....old version of access

i need to connect to .accdb....2007 and 2010 version of access

connect to Access 2010

Wed, 30 Nov 2011 15:51:00 GMT

figured it out...had to add new accdb driver

connect to Access 2010

Fri, 23 Mar 2012 16:05:19 GMT

HI ,

Are you able to explain how to add the accdb driver? I am havign the same problem.

thanks

dan

Re: connect to Access 2010

Fri, 23 Mar 2012 16:05:47 GMT

HI ,

Are you able to explain how to add the accdb driver? I am havign the same problem.

thanks

dan

connect to Access 2010

Mon, 26 Mar 2012 09:24:53 GMT

adding driver depends upon ur windows....wheather its 32 or 64 bit...in 64 bit windows you will face problem.....search for SysWow64 and run odbcad32 and add DSN

connect to Access 2010

Fri, 06 Apr 2012 12:15:57 GMT

Hi,

Try to use ODBC Data Source Administrator. You must create system DSN with your database. Then in the edit script dialog, you must connect to system data source.

I think it helps you.

Regards, Bill

Re: connect to Access 2010

adhudson — Thu, 12 Apr 2012 01:41:08 GMT

Hi,

The *.accdb files are being used in different formats, the Provider to link with the database also changes.

You can see the provider name in the connection string.

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

This provider will only be available if you have installed MS Office 2007 or above.

Please find the attached sample qvw file.

Regards

Andrew Hudson