RE: Syntax Help

[allyne]

Hi everyone,

How can I export the result of this qry to an excel spreadsheet template on H:\Test.xls within a stored procedure. Would Like to have this in a stored procedure and not a DTS package.

Select AccountNumber,Name,Address
FROM TEMP
WHERE Left(Type,11) = 'Printed'

Thanks for your help!

 

[NoCoolHandle]

The only way I can think to do this is to use xp_cmdshell and osql to create an output file on you hard drive...

something like

exec master.dbo.xp_cmdshell 'osql -E -Q"select name from sysobjects where type=''u''" -oc:\output.txt'

note -E = trusted connection -o = output file

all parameters are case sensitive.


HTH

Rob

 

[jhall156]

You could try using Excel automation with sp_OACreate etc.

JHall

 

[allyne]

Thanks for all your help!