I have created a sql 'distinct' query to return more than one column of data from an oracle database. I want to write this to an excel sheet, but i am unable to parse this information out in the same format as what i get when viewing the result in SqlPlus editor.
Here is an example of what i want to write out to the excel sheet:
I want to use the excel sheet to import it into the datatable keeping the original database table headers.
<font size="2" face="Verdana, Arial, Helvetica">For this you can create a sepreate recordset and query the excel sheet, there is one option for ignoring the column headers that you need to give in your connection string.