Opening Excel from ASP

Results 1 to 3 of 3

Thread: Opening Excel from ASP

  1. #1
    HueyD Guest

    Default Opening Excel from ASP

    I&#039;m dumping a recordset into excel using;<BR><BR>response.buffer = true<BR>response.ContentType = "application/"<BR>response.AddHeader "content-disposition", "inline;filename=results.xls"<BR><BR>One of the rows is text with strings such as 0125, 012d, 013f.<BR>The problem is that excel converts the data with all numbers to number format and leaves the others as text. Is there a way I can force excel to import the column as text only?

  2. #2
    Join Date
    Dec 1969

    Default RE: Opening Excel from ASP

    I&#039;d like to know how to do this too but I haven&#039;t done any of this stuffs. Any chance that you can direct me to some reading material?<BR><BR>Thanks

  3. #3
    Join Date
    Dec 1969

    Default RE: Opening Excel from ASP

    Go to <BR> CH&SPR=ASP<BR><BR>Good article and examples

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts