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