Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Import a table Access

How to import a table Access with qlikSense? Thank you

3 Replies
jananireddy
Contributor

Re: Import a table Access

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
Valued Contributor II

Re: Import a table Access

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

Not applicable

Re: Import a table Access

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

Thank.

Community Browser