I tried to run a query today and have the results go to a file. The output was a ton of rows with only one column. If you need to output query analyzer results to a format compatible with Excel just do the following:
- Go to “Tools”
- Click “Options”
- Click the “Results” tab
- Under “Results output format: (*)”, select “Tab Delimited”
- Make sure “Print column headers (*)” is selected
- Click “OK”
Now when you run your query the results will be in TSV format with the column headers.