Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

connect to Access 2010

anyone know how to connect to Access 2010?

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

11 Replies
SunilChauhan
Esteemed Contributor

connect to Access 2010

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

now click on select-> select your table and reload

Not applicable

connect to Access 2010

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?

SunilChauhan
Esteemed Contributor

connect to Access 2010

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

SunilChauhan
Esteemed Contributor

connect to Access 2010

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

Not applicable

connect to Access 2010

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

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

Not applicable

connect to Access 2010

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

Not applicable

connect to Access 2010

HI ,

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

thanks

dan

Not applicable

Re: connect to Access 2010

HI ,

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

thanks

dan

Not applicable

connect to Access 2010

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