how to write into an Excell

kotasateesh · #1 (**permalink**) 07-28-2006

Hello All,
I have a query inside a shell script and it will retun a 1000 rows result set. how can i take the output into an excel file from the script for better viewing the results.

Thanks,
Sateesh

arunkumar_mca · #2 (**permalink**) 07-28-2006

hi,

U can use

isql -Username -Ppassword -Ddatabse -Sserver -iinputfilename -ooutputfilename -w1200 -s,

Here input filenaem should cntin the query you want

Ex:

inputfilename

select * from Accounts
go

note go should be there

Thanks,
Arun

kotasateesh · #3 (**permalink**) 07-28-2006

Thanks Anil,
How about if i have a stored proc but not a sql query

arunkumar_mca · #4 (**permalink**) 07-28-2006

HI,

First i am not Anil i am arun

second

if u are running a proc u can do as

inputfilename

select * from Accounts
go

instead of

inputfile name

exec yourproc
go

Thanks,
Arun.

kotasateesh · #5 (**permalink**) 07-28-2006

Sorry for specifing the wrong name Arun. I will try this.
Thanks for your help.

Thanks,
Sateesh

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Write to a CD in SCO	zmaster18	SCO	4	04-10-2008 05:04 PM
how to write to Solaris BSM log	JDO	High Level Programming	0	01-04-2008 04:01 PM
how to write	LAKSHMI NARAYAN	Shell Programming and Scripting	2	07-13-2007 09:50 AM
How to Write RPM	kjannu	UNIX for Dummies Questions & Answers	1	06-23-2006 09:23 AM
tar write err	Kevin Pryke	UNIX for Dummies Questions & Answers	4	05-17-2002 10:35 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by