add extra table from access database

Thu, 24 Sep 2015 08:46:20 GMT

Hi,

I'm new to qlikview. I'm trying to add tables from an access database.

I created the odbc connection to an existing access database, and added one table. All fine so far.

Now, I want to add extra tables from the same .mdb file.

Si I went back to the script editor, and clicked in the first tab (Data) on the 'select' button.

but this forces me to navigate again to the access file.

Is there no way to see all tables from the previously selected datasource via point & click, without having to do the navigation again?

thx,

Tom

Re: add extra table from access database

hic — Fri, 25 Sep 2015 09:29:02 GMT

If you do the following, QlikView will remember the path to the file:

Define a new data source in the ODBC administrator, using a file name. If you use the generic MS Access data source, that lacks file name, it will not work.

HIC

topic Re: add extra table from access database in QlikView

add extra table from access database

Re: add extra table from access database