topic Sending Qlikview straight table to MS sql database using macro in QlikView

Sending Qlikview straight table to MS sql database using macro

riho92qv — Mon, 26 Jan 2026 16:26:21 GMT

i have similar tables, in QlikView straight table and table in MS SQL database. These tables have the same structure and also match the data types. I need every month to add the last month's data from this Qlikview table to the SQL database table.

So far, I have copied the table to Excel and sent it to the database using the VBA procedure. Can I do this directly from Qlikview using the appropriate macro.

Riho

Re: Sending Qlikview straight table to MS sql database using macro

Chip_Matejowsky — Tue, 09 Mar 2021 17:27:54 GMT

HI @riho92qv,

You're looking to "write back" to the database from QVW using QlikView Desktop?

Best Regards

Re: Sending Qlikview straight table to MS sql database using macro

riho92qv — Tue, 09 Mar 2021 21:27:59 GMT

Not quite back, because the data that is written to the database comes from different data sources, not just the database where I want to write it. Qlikview aggregates data from different data sources and processes them. I really want to write the result to a database so that it can be conveniently used in applications other than Qlikview.

Riho

Re: Sending Qlikview straight table to MS sql database using macro

riho92qv — Wed, 17 Mar 2021 07:41:21 GMT

unfortunately, as I did not receive an answer to my question, I still had to find it myself. After long experiments, I found a suitable solution for myself. Maybe it's not the most elegant, but it works. In addition to the macro in Qlikview, I used the SQL stored procedure. Unfortunately, my solution can only use integers.