| || |
output to Excel file
I need to output ALL the values of a table to a excel sheet.
I make a new connection, open is and then execute the query say Select * from TabA.
Now I need to return the entire set in to a Excel worksheet. I know how to do for select cells. But is there a way to return the entire Recordset to the excel?
Re: output to Excel file
This example shows how to do it for an excel sheet, same principle though :