hello all,

I need to read a .txt file and then put that into fields in an excel spreadsheet. for example i get print spool files that have invoices on them i need to put the customer names into a column of customer names and their addresses into a column of addresses. here is what i wrote to read with:
Code:
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim reader As New System.IO.StreamReader(TextBox1.Text)
        TextBox2.Text = reader.ReadLine()
        reader.Close()
    End Sub
as you can see i just have it outputting to a second textbox so i could see that it was reading properly.
I am very green with programming in general so please be exhaustive with your suggestions. thank you in advance.