Export to Excel sheet

[Luke Zhang [MSFT]]

You may refer to this KB article:

[url]http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q288130[/url]

Luke

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Lin Ma]

Thanks XR.

The function code works great. It fix my problem when user has a line break
in the text box.

Thanks a lot.

Lin


"XR" <xrongg@yahoo.com> wrote in message
news:0b7a01c33cb6$e2467a90$a401280a@phx.gbl...

> [CSV use , as default dilimiter. ]
>
> iID = rs("ID")
>
> sTemp = iID & "," & stringTOCSV(rs("taname")) & ",," &
> stringTOCSV(rs("Countryname"))
>
> f.writeLine(sTemp)
>
> '--------------------------
> ' Convert input string to fit the CSV formating '
> ' Returns formated input string '
> '--------------------------
>
> function StringToCSV(xIn)
> Dim xOut
> if not xIn = "" then
> xOut = Trim(xIN)
> xOut = replace(xOut, """", """""")
> xOut = """" & xOut & """"
> StringToCsv = xOut
> Else
> stringToCsV = xIn
> End if
> End function
>
>

> >-----Original Message-----
> >Thanks. But it only write to one column. How to write

> more than one column?

> >
> >I try to use f.WriteLine ("The information you want") &

> ("this is column

> >2")
> >
> >But it is not working.
> >
> >Thanks,
> >
> >Lin
> >
> >
> >"XR" <Xrongg@yahoo.com> wrote in message
> >news:026c01c33c1d$f0e60370$a501280a@phx.gbl...

> >> sFName = "ReportCache\Report_time.csv"
> >>
> >> set fs = server.createObject

> ("scripting.fileSystemObject")

> >> set f = fs.createTextFile(server.mappath(sFName))
> >> sql = your sql statement
> >> Set Rs = conn.execute(sql)
> >> if not rs.eof then
> >> do while not rs.eof
> >> f.WriteLine ("The information you want")
> >> rs.moveNext
> >> loop
> >> end if
> >> rs.close
> >> set rs = Nothing
> >>
> >> set f = Nothing
> >> set fs = Nothing
> >>
> >>
> >>

> >
> >
> >.
> >

[Lin Ma]

Thanks Curt.

Now I know how to convert a table into Excel. Cool.

Lin Ma


"Curt_C [MVP]" <Software_AT_Darkfalz.com> wrote in message
news:OvbDw$CPDHA.704@tk2msftngp13.phx.gbl...

> Using Excel from ASP
> [url]http://www.darkfalz.com/1085/[/url]
>
>
> --
> ----------------------------------------------------------
> Curt Christianson (Software_AT_Darkfalz.Com)
> Owner/Lead Designer, DF-Software
> [url]http://www.Darkfalz.com[/url]
> ---------------------------------------------------------
> ..Offering free scripts & code snippits for everyone...
> ---------------------------------------------------------
>
> "Lin Ma" <a@a.com> wrote in message
> news:#NmPfkBPDHA.2160@TK2MSFTNGP11.phx.gbl...

> > Hi,
> >
> > From my asp page, after user run a search query, I need this query

result

> to

> > be displayed in a spread sheet. A csv file?
> >
> > Does anyone know how to do?
> >
> > Thanks,
> >
> > Lin Ma
> >
> >

>
>