Question
Mphasis Unleash the Next
IN
Last activity: 25 Jun 2018 16:09 EDT
How to get the all data from EXCEL by the sql query or stored procedure?
Hi,
Please explain me how to get the data from excel and insert the data into excel file by the SQL Query(ex: select * from Sheet1).
I tried but getting none values/no data coming. Can anyone explain end to end process on that?
Thanks.
Verizon Data Services
IN
You can check the below link . If you can elaborate the requirement as to what is the purpose of running the sql while reading the data from the excel then something can be though of .
https://forums.asp.net/t/1632867.aspx?How+to+read+excel+file+and+write+into+table+through+sql+query
Mphasis Unleash the Next
IN
Thanks Nikhil to respond on my query.
In my requirement, need to get the values from fields available in the application(around 50 fields has to capture) and those fields has to export to excel file.
by the query can write all at a time and calculations has done in the query as well. That's why I want to use query to export the fields values instead of using long development automation components blocks.
we have OleDB query, ODBC query, SQL Query, etc components to write the query to perform DDL and DML commands. Which one has to use and how to use to export the data from automation to excel by the query.
Thanks
Pegasystems Inc.
US
I'm having trouble understanding what exactly you want to do and what you are trying to avoid doing. It sounds like you want to export some data from the application to Excel. If you do not want to use a report definition to do this, then you should look into our BIX (Business Intelligence Exchange) product. One of the things it is specifically designed to do is to export application data to Excel.