extracting data to excel

Hi ,
How can i extract or export data into excel sheet from sql server 7.

Use dts on sql7.

sorry, its sql server 6.5. Can you give the steps to use data transfer service

If you have SQL 7.0 and up anywhere then you can use DTS from there to pull data out of SQL 6.5 and export to Excel.

Otherwise you will need to use BCP.

Please eloborate your answers. there are Junior readers need more clearer idea. And how to BCP?

You can find details in sql books online.

Can we generate some colourful or customized excel sheet using sql query.Am using following query for testing.the code is working fine.
How to add some styles in the generated excel sheet,:confused:

EXEC sp_makewebtask
@outputfile = 'd:\testing.xls',
@query = 'Select * from Database..Table_Name',
@colheaders =1,
@FixedFont=0,@lastupdated=0,@resultstitle='First_N ame,Last_Name,Address from Table_Name'

Regards

It's nothing to do with sql.

Not with SQL, but you can with something like VBA in Excel or VBA via a VBScript. There are plenty of examples in the SDK for VBA for Excel on MSDN.