Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-11-30 09:36 AM

connect to Access 2010

anyone know how to connect to Access 2010?

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

7,786 Views
0 Likes
11 Replies
Not applicable
‎2012-04-06 08:15 AM
Author

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

192 Views
0 Likes
adhudson
Creator II
Creator II
‎2012-04-11 09:41 PM

In response to

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

DB.qvw
192 Views
0 Likes