Sending Qlikview straight table to MS sql database using macro
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.
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.
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.