Can anyone show me how to change the font color using SQL Server? The below is the programming style I'm using.


-- SET cell format to Currency two digits
EXECUTE @rs = master.dbo.sp_OASETProperty @xlCell, 'NumberFormat', '$#,##0.00'

This article helps me so much.
But i need one more help on this.
Suppose my Column A has integers that comes from Stored procedures.
I want to apply formatting (like 0000,0000.00,-0000.00,etc). How to achieve this? Can you help me on this?
Thanks in advance.

I use OPENROWSET to write an SQL query output to Excel. The problem I'm having is that all my numeric fields end up in Excel as text strings. Does anyone know how to make them be numbers in Excel?

Thanks

What I need install on SQL 2008 64bit for create excel 2007 worksheets?Is it not possible to install full Office 2007 to server.
Our admins tried install this
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734
but no happened and when I try run
spExecute_ADODB_SQL @DDL='Create table CambridgePubs
(Pubname Text, Address Text, Postcode Text)',
@DataSource ='C:\CambridgePubs.xls'
I get this error
Msg 50000, Level 16, State 1, Procedure spExecute_ADODB_SQL, Line 105
Error whilst Opening Connection to XLS, for file Create or Append, Provider cannot be found. It may not be properly installed.

maybe is problem in spExecute_ADODB_SQL. Can I use this or have I edit with new?I think Excel 2007 is Excel 12.0?
@ConnectionString VARCHAR(255)

= 'Provider=Microsoft.Jet.OLEDB.4.0;

Data Source=%DataSource;

Extended Properties=Excel 8.0'

maybe is problem in spExecute_ADODB_SQL. Can I use this or have I edit with new?I think Excel 2007 is Excel 12.0?
@ConnectionString VARCHAR(255)

= 'Provider=Microsoft.Jet.OLEDB.4.0;

Data Source=%DataSource;

Extended Properties=Excel 8.0'

Hello,

I am new to T-SQL.I have to develop excel report from sqlserver So I want to know how should I start and what needs to be downloaded for this purpose

I wanted to create excel sheet from Stored procedure with some formatting.I have copied the code after downloading it but i am getting the following error when running it.
"sp_OAMethod usage: ObjPointer int IN, MethodName varchar IN [, @returnval <any> OUT [, additional IN, OUT, or BO"

I was using the following command to run it

spDMOExportToExcel @SourceServer='My DB Server Name',
@QueryText = 'use MyDatabase select Pubname, Address, Postcode from ##CambridgePubs',
@filename = 'C:\MyPubDatabase.xls',
@WorksheetName='MyFavouritePubs',
@RangeName ='ABCDE'

Am i missing something?What does the Parameter @Range Expect.

I wanted to create excel sheet from Stored procedure with some formatting.I have copied the code after downloading it but i am getting the following error when running it.
"sp_OAMethod usage: ObjPointer int IN, MethodName varchar IN [, @returnval <any> OUT [, additional IN, OUT, or BO"

I was using the following command to run it

spDMOExportToExcel @SourceServer='My DB Server Name',
@QueryText = 'use MyDatabase select Pubname, Address, Postcode from ##CambridgePubs',
@filename = 'C:\MyPubDatabase.xls',
@WorksheetName='MyFavouritePubs',
@RangeName ='ABCDE'

Am i missing something?What does the Parameter @Range Expect.

I wanted to create excel sheet from Stored procedure with some formatting.I have copied the code after downloading it but i am getting the following error when running it.
"sp_OAMethod usage: ObjPointer int IN, MethodName varchar IN [, @returnval <any> OUT [, additional IN, OUT, or BO"

I was using the following command to run it

spDMOExportToExcel @SourceServer='My DB Server Name',
@QueryText = 'use MyDatabase select Pubname, Address, Postcode from ##CambridgePubs',
@filename = 'C:\MyPubDatabase.xls',
@WorksheetName='MyFavouritePubs',
@RangeName ='ABCDE'

Am i missing something?What does the Parameter @Range Expect.

I wanted to create excel sheet from Stored procedure with some formatting.I have copied the code after downloading it but i am getting the following error when running it.
"sp_OAMethod usage: ObjPointer int IN, MethodName varchar IN [, @returnval <any> OUT [, additional IN, OUT, or BO"

I was using the following command to run it

spDMOExportToExcel @SourceServer='My DB Server Name',
@QueryText = 'use MyDatabase select Pubname, Address, Postcode from ##CambridgePubs',
@filename = 'C:\MyPubDatabase.xls',
@WorksheetName='MyFavouritePubs',
@RangeName ='ABCDE'

Am i missing something?What does the Parameter @Range Expect.

I wanted to create excel sheet from Stored procedure with some formatting.I have copied the code after downloading it but i am getting the following error when running it.
"sp_OAMethod usage: ObjPointer int IN, MethodName varchar IN [, @returnval <any> OUT [, additional IN, OUT, or BO"

I was using the following command to run it

spDMOExportToExcel @SourceServer='My DB Server Name',
@QueryText = 'use MyDatabase select Pubname, Address, Postcode from ##CambridgePubs',
@filename = 'C:\MyPubDatabase.xls',
@WorksheetName='MyFavouritePubs',
@RangeName ='ABCDE'

Am i missing something?What does the Parameter @Range Expect.