Dear Shilpa,
Here are the ways to export your data from QlikView to ".csv" or ".xls" file format.
1. Store .CSV file using Script: You can store data in ".csv" file format by using given below statement. Given below statement should be write in your script.
STORE YourTableName into myNewTable.csv (txt, delimiter is ',');
2. Send to Excel: This option can be enabled over the chart and you can export the data in a excel file format, Here is the way to enable the option
Right Click on Table Object > Properties... > Caption Tab > Special Icons > Checked to Check Box "Send to Excel" > Apply > OK
A little icon will appear upper right hand side with "XL" icon with tool tip "Send to Excel" just click on the icon and export your data in ".xls" file format.
Save As your excel file in your required location with appropriate name and load or performance action whatever you want (means you can load exported data into Oracle).
Kind regards,
Ishfaque Ahmed
