Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QV Community,
I am trying to load QV data into SQL as a test without using VB and dont seem to have any luck. I am using the below script, and it is erroring out, can someone help?
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Clinicom_Temp;Data Source=LPTLoad01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=QVLPT01;Use Encryption for Data=False;Tag with column collation when possible=False];
T1:
LOAD * INLINE [
F1, F2
F, 6
G, 7
H, 8
I, 9
J, 10
];
For i= 0 to NoOfRows('QVtoSQL') -1
LET V_F1 = peek('F1',$(i),' QVtoSQL ');
LET V_F2 = peek('F2',$(i),' QVtoSQL ');
SQL INSERT INTO QVtoSQL (F1,F2) VALUES('$(V_F1)','$(V_F2)');
NEXT
Make sure to enable the option Open Database in Read and Write Mode on the Settings tab of the script editor. Otherwise the connection will be read-only. And of course the user you connect as needs insert priviliges in the target database.
Hi,
Its not possible to directly push the data from QlikView to Database.
Have a look at the link for the way to do this.
http://community.qlik.com/docs/DOC-3054
http://community.qlik.com/docs/DOC-2784
Regards,
Kaushik Solanki
where do i find this? sorry i am a novice
interesing, a lot of macros can cater for this though
Hi,
It depends on which way is convenient for your scenario.
Regards,
Kaushik Solanki
i just wanted to try a test as above and build on it...