[RESOLVED] Newbie - CSV to Dataset

[jmcilhinney]

If you want to use ADO.NET then you'll need to pre-process the data to remove those quotes because it's not a proper CSV file with those. You could do this:

Dim filePath As String = '...
Dim lines As String() = IO.File.ReadAllLines(filePath)
 
For index As Integer = 0 To lines.GetUpperBound(0)
    lines(index) = lines(index).Trim("""")
Next
 
IO.File.WriteAllLines(filePath, lines)

That's going to save the data back to the same file without the leading and trailing quotes. You can then use ADO.NET to read the data straight into a DataTable.