Import a table Access

[#1]

How to import a table Access with qlikSense? Thank you

[jananireddy]

Hi, I am not too sure of what you mean by table access with Qlik sense. But if you are looking at restricting tables in the database for the users ... please go through this post

Question of Database table access restriction v... | Qlik Community

[martinpohl]

Do you mean a table from Microsoft Access?

Create new App

Goto Data Editor

Create new Connection (on the right hand)

Select OLE DB

Select Microsoft Jet 4.0 for a MdB or Microsoft Office 12.0 Access as Provider

Enter the Folder of your Database and if neccessary User and Password (Test connection)

Finish the creation, a new Connection is created

Click on select data

on the right hand you can select your tables from your Access Database. Select them and the wizzard will create a script

Regards

[#4]

I can create the connection but after click on add data after a few seconds the error mask, why?

Thank.