How do I parse a comma delimited file into a dataset using ado
Posted on 2005-03-16
The issue I have is that the file is labelled .log, but is basically a csv file. I was hoping I could just read it straight into a dataset.
I am not to sure what the best method is, i suspect at this stage that extra commas and quoting isnt an issue(...yet)
I have tried this connection...
strConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & qStrSQL(gcConfig.CounterLog) & ";Extended Properties=""Text;HDR=No;FMT=Delimited\"""
but it doesnt seem to like it :o(