I am completely new at all this and learning as i go. I am pulling data from excel using sql query.
“Select * From [Sheet1$A39:R75] Where [F1] = “+Target+”” and storing the above in Datatable
Then i am using “Output Data Table” to put the Datatable in a string and storing in Datatable2
This is the output i get:
I wish to get the numbers between the two \r\n
I am not sure why i am getting the Headers and New Line when my sql connection string has HDR=NO
I used the following query
But i get the following output:
Can this be implemented in the select query as i like to minimise the number of actions otherwise please show how i can get the result of the following:
Could someone please assist me with this.
Thank you in Advance