SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 
        
Home       Members    Calendar    Who's On



sql table to excel Expand / Collapse
Author
Message
Posted Tuesday, July 01, 2008 7:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 14, 2008 3:31 PM
Points: 3, Visits: 22
hello...i am able to export a table from sql server to excel..my requirement is..if a column is of money datatype in sql server it should be displayed in $####.## format in excel and the excel column width should automatically resize according to length of data..
Post #526632
Posted Tuesday, July 01, 2008 9:02 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:38 AM
Points: 1,275, Visits: 3,218
You may have to do a little bit of VBA in the excel spreadsheet for this to happen automatically

Post #526719
Posted Tuesday, July 01, 2008 9:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 14, 2008 3:31 PM
Points: 3, Visits: 22
there is a button called open in excel on my asp.net appication that should do it..
Post #526729
« Prev Topic | Next Topic »


Permissions Expand / Collapse