StreamWriter to CSV File - Write to Next Line

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Redwinger354
    New Member
    • Mar 2008
    • 2

    StreamWriter to CSV File - Write to Next Line

    Hello All,

    I have the following code below which writes to my CSV file successfully.
    Now how do I get it to write a new record on the Next line/Row?

    Code:
     Dim objWriter As IO.StreamWriter = IO.File.AppendText(_strCustomerCSVPath)
    
                If IO.File.Exists(_strCustomerCSVPath) Then
                    objWriter.Write(_CustomerID & ",")
                    objWriter.Write(_FirstName & ",")
                    objWriter.Write(_LastName & ",")
                    objWriter.Write(_Phone & ",")
                    objWriter.Write(_Email & ",")
                    objWriter.Write(_Address & ",")
                    objWriter.Write(_City & ",")
                    objWriter.Write(_State & ",")
                    objWriter.Write(_ZipCode)
                Else
                    MsgBox("Does not exist")
                End If
    
                objWriter.Close()

    Thanks for the help!

    Regards,
    James
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Question moved to .Net forum.

    Comment

    • Redwinger354
      New Member
      • Mar 2008
      • 2

      #3
      WriteLine() did the job!

      Comment

      Working...