[2005] From Access to String or to Array

I have an access Database that I want to read some data from, now I know how to connect to the database and Open and close it, but from there I am stuck, all I want to do is take a specific column in one of the Tables and read out of it row by row and add it to a string ... So this is what I have so far ...

Code:

---

Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim DBCon As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source= *my database source*")
        DBCon.Open()

**here I need to go through each row and add the column's data to a string or an array (I'd prefer it being a string)**

        DBCon.Close()
End Sub

---

I have tried googling for this but I am unsure on what to search for so I'm not getting the relevant results ...

Hi there,
Here are some good links to help you get started. Read the first article first. Good luck.
http://vbforums.com/showthread.php?t=469872
http://msdn2.microsoft.com/en-us/lib...60(vs.80).aspx

http://www.vbforums.com/showthread.php?t=469872

The second example will be of most interest to you.

Edit: Shazzam!

Oh my!!! What legends you are ...

@ jmcilhinney: I thought I had lots of posts at ozzu.com ... but I was wrong ... lol ... nice