CSV file

Results 1 to 3 of 3

Thread: CSV file

  1. #1
    Join Date
    Dec 1969

    Default CSV file

    Does anyone know how to create .CSV file from ASP and how to link it with database to generate a report ?<BR><BR>Thanx in advance.<BR>Ani.

  2. #2
    Join Date
    Dec 1969

    Default RE: CSV file

    it&#039;s easy to generate. just write it out with FileSystemObject like you would any other textfile. now getting a report? that&#039;s different and I can&#039;t help you there

  3. #3
    Richard S Guest

    Default RE: CSV file

    &#060;%<BR>Set filesys = CreateObject("Scripting.FileSystemObject")<BR>Set peoplefile = filesys.OpenTextFile(server.mappath("/file.csv"), 1)<BR>Do While Not peoplefile.AtEndOfStream<BR> outputstring = peoplefile.ReadLine<BR><BR> Response.Write outputstring & "(br)"<BR>Loop<BR>peoplefile.Close<BR>%&#062;<BR>< BR>...This code will output each line of the csv file. But to get each element (I.E. inbetween the commas) you will have to do a bit of string manipulation within VBScript. Which is a little bit more involved.

Posting Permissions

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