Ok, me again. When I add the records into the database, I am getting the aryFields(#) instead the called index in the array. I look at everything and can't see why I'm not getting the desired data instead of the aryFields() written into the database. Uugh.
Private Sub btnLoadFromText_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadFromText.Click 'declare the database Dim db As New dbUpdt Dim strRecord As String ' for each line (record) from the CSV file Dim aryFields() As String ' array to contain fields Dim strID As String ' for the station ID 'declare the source of the database file 'create connection to the database db.openConnection("weather.mdb") 'open & read text Dim stationsFile As StreamReader = File.OpenText("stationsIn.csv") ' continue processing until I hit the end of CSV file Do Until stationsFile.EndOfStream ' read a record and split into fields strRecord = stationsFile.ReadLine aryFields = Split(strRecord, ",") ' Determine the value of the key field strID = aryFields(0) db.addRecord("stations", "StationID", "aryFields(0)") db.setField("stations", "StationID", "aryFields(0)", "StationName", "aryFields(1)") db.setField("stations", "StationID", "aryFields(0)", "State", "aryFields(2)") Loop ' read one line and store in database End Sub