Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
alberto_pozzi
New Contributor II

How can I run a sql query??? - QlikView Server

hi

how can I run a query on a db using a macro??

on the desktop version i use this macro:

set con = CreateObject("ADODB.Connection")

    con.Open("Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\demo_sviluppo\Budget_Vendite\Bgt_Salvataggi.accdb;")

  ins = "INSERT into Bgt_Salvataggi values ('3','ciao')"

  con.execute(ins)

    con.Close

I need help on the server version??

thanks for the replies!

2 Replies
Partner
Partner

Re: How can I run a sql query??? - QlikView Server

I guess you are running x64 server.

No x64 ODBC driver exists for MS Access?

Not applicable

Re: How can I run a sql query??? - QlikView Server