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

[Anonymous]

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!

[jerrysvensson]

I guess you are running x64 server.

No x64 ODBC driver exists for MS Access?

[#3]

Hello!

try to look here

64 bit driver for DSN for MS access database - Microsoft Community