how to export SQL data into an excle file?

[Jana.Luo]

Hi there,
I have a SQL query and want to export the data table to an excle file. how can i do it?

Thanks a lot in advance!!!
Jana

 

[pbornemeier]

If the file has already been downloaded from the soruce system, you can open with Excel.
If you want to use Excel to perform the query, the exact method depends on the version of Excel. With Excel 2007, on the Data tab, in the Get External Data block, select the From Other Sources and select th eitem appropriate to your situation.