A
Aliza Klein
I am new to ASP so please pardon me if this is crazy.
I have data that I want to allow the user to be able to save in a format
that will then enable the user to open the data in Excel. (I have already
read the previous CSV posts and still have a question.)
I have an ASP page that takes some data from a previous page,adds some
column headings and displays it all in apparent CSV format.
All I am trying to do is allow the users to do a Save As (for a text or CSV
file) and open it (in Excel) with the proper columns. Somehow, although all
appears OK on the screen, when saving the file, line feeds seem to be added
and all the rows get messed up. If I simply select all the text on the ASP
page and copy it to WordPad, save it, and open it in Excel - all works fine.
Obviously there is some formatting I am overlooking.
Any suggestions would be helpful! (The page can be viewed at
http://primefreight.ca/database1_interface/Results/track_company.asp and
search on TEST COMPANY as the company, press Track and then the Export
button.)
I am baffled and feel I am so close... but getting frustrated.
Thanks for any input!
Aliza
I have data that I want to allow the user to be able to save in a format
that will then enable the user to open the data in Excel. (I have already
read the previous CSV posts and still have a question.)
I have an ASP page that takes some data from a previous page,adds some
column headings and displays it all in apparent CSV format.
All I am trying to do is allow the users to do a Save As (for a text or CSV
file) and open it (in Excel) with the proper columns. Somehow, although all
appears OK on the screen, when saving the file, line feeds seem to be added
and all the rows get messed up. If I simply select all the text on the ASP
page and copy it to WordPad, save it, and open it in Excel - all works fine.
Obviously there is some formatting I am overlooking.
Any suggestions would be helpful! (The page can be viewed at
http://primefreight.ca/database1_interface/Results/track_company.asp and
search on TEST COMPANY as the company, press Track and then the Export
button.)
I am baffled and feel I am so close... but getting frustrated.
Thanks for any input!
Aliza