Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QliView to DataBase

Hi everyone,

Please how to insert data directly through a form , from QlikView to database ( Access 2007 )?

Regards.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi

QlikView is a BI Dashboard / Analysis tool that is very good at reading data from databases and is not designed to write to them.

There are various methods, some most obtuse, to warp what is was designed for and write back to databases, but I personally concentrate on QlikView's out of the box strengths.

Best Regards,     Bill

View solution in original post

5 Replies
Anonymous
Not applicable
Author

Hi

QlikView is a BI Dashboard / Analysis tool that is very good at reading data from databases and is not designed to write to them.

There are various methods, some most obtuse, to warp what is was designed for and write back to databases, but I personally concentrate on QlikView's out of the box strengths.

Best Regards,     Bill

Clever_Anjos
Employee
Employee

Best way (and easiest) is exporting to csv and importing using your database tools

Anonymous
Not applicable
Author

Hello,

Qlikview not can insert data to DataBase

Not applicable
Author

thanks a lot for your reply...

mark_casselman
Creator
Creator

Hi,

In fact QlikView CAN insert data into databases. It is not standard functionality, but it can be done through macros. Check some other articles on the forum and/or try google.

For example check thread http://community.qlik.com/thread/61660

Mark