Dynamic creation of Excel file by exporting MSSQL data

• sunil-857582

  Grasshopper

  Points: 18

  More actions

  August 27, 2008 at 11:32 pm

  #197588

  I have a situation where in I need to create a excel file from java code for which data is coming from a select statement of MSSQL.

  I was doing this kind of stuff when I was working with MYSQL5.0 by using the following code.

  SELECT a,b,a+b INTO OUTFILE '/tmp/result.xls'

  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

  LINES TERMINATED BY ''

  FROM test_table;

  Any thoughts/suggestions?

• GSquared

  SSC Guru

  Points: 260824

  More actions

  August 28, 2008 at 7:39 am

  #864374

  I suggest SSIS. It can do that kind of thing quite easily.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• w.durkin@online.de

  Hall of Fame

  Points: 3943

  More actions

  August 28, 2008 at 9:03 am

  #864485

  Hi,

  this topic came up a while back. Please check this to see if it helps at all: http://www.sqlservercentral.com/Forums/Topic487837-19-1.aspx

  regards

  GermanDBA

  Regards,

  WilliamD

• sunil-857582

  Grasshopper

  Points: 18

  More actions

  August 28, 2008 at 11:03 pm

  #864835

  thanks guys..i got it...