Can I export SQL table output to excel?
Posted on 2011-03-18
I have some SQL query's that output the data in table format when executed. I am just wondering if there is a way to automatically pull the data from the table to an excel file. Or more specifically, pull parts of the data to specific parts of an excel file. Like say pull the data from the second column of the query ouput and place it in excel Column C (below current data if possible). Or even match up dates (which are part of the SQL output) to the dates in column A of the excel file.
I have a feeling this isn't possible or is way more work then its worth, but I wanted to check and see. I know I can highlight and copy data over, but I'm hoping for more automation. Thanks for the help.