2 Replies Latest reply: Jan 20, 2011 7:15 AM by John O'Mahoney RSS

    Returning data from access database

      I am new to qilview so appologies if there is a simple solution to this

      I have Qlikview installed on my laptop and a simple Access 2003 database

      I create an OBDC connection to the Access database - Microsoft Access Driver (*.mdb) as a system DSN

      In 'edit script' i connect using the ODBC to the access database, I select all the fields from one table and add them to the script. The preview tab can see the data ok.

      Back in 'Edit Script' I reload and get 'ODBC connection failed'

      what am I doing wrong please