I agree and think option 2 is the way to go no reason not to that I can think of, why create something only to delete anyway if you can just not create it to begin with. So this is what I have but there seems to still be some fields that have no data in them that are being added, I dont know what else to test for ? I just have the msgobx temporarily to test

Code:
While Not myReader.EndOfData
                Try

                    currentRow = myReader.ReadFields()
                    Table.Rows.Add(currentRow)

                    If String.IsNullOrEmpty(myReader.ReadFields(0).ToString) = True Then
                        MsgBox("String was Null or Empty")
                    ElseIf myReader.ReadFields(0).ToString = "" Then
                        MsgBox("String was quotes")
                    Else
                        MsgBox(myReader.ReadFields(0).ToString)

                        Table2.Rows.Add(currentRow)