Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

add extra table from access database

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

1 Reply
hic
Former Employee
Former Employee

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