Post reply

sql table to excel

  • July 1, 2008 at 7:45 am

    #188890

    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..

  • July 1, 2008 at 9:02 am

    #836758

    You may have to do a little bit of VBA in the excel spreadsheet for this to happen automatically

  • July 1, 2008 at 9:12 am

    #836766

    there is a button called open in excel on my asp.net appication that should do it..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply