ASP to Excel Problem

[toddsalcedo]

I have an ASP search page that contains a button that allows the user to download the results of the database search to an Excel file. The Excel file contains two date columns, but they will not properly sort nor will they format into Date type columns.

They are datetime columns in the database, but that seems to get lost in the download. Is there a way to force the download to pre-format the dates as date data so that it can be soreted in Excel?

 

[onpnt]

are you setting the cells to the format you want?

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[ggriffit]

check out

http://www.greggriffiths.org/webdev/both/excel/

for some samples.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005

http://www.greggriffiths.org/livelink/