I don't speak the ASP, but maybe....

strXls = strXls & replace(fld.value,vbCr,vblf)

or

strXls = strXls & replace(fld.value,char(13),Chr(10))

Without knowing what strXLS or fld.value is, either.

Lorenzo wrote:

hi to all, sorry for my little little english.

i wont to export in excel from sql by asp

if in a field there is a chr(13), excel send to new row the text. What i do
to tell excel go in a new line in the same cell?

i try so but don't work:

strXls = strXls & replace(fld.value,vbCrLf,Chr(10))

many thanks

Lorenzo

--

Dave Peterson