Milkus1
asked on
How do I parse a comma delimited file into a dataset using ado
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.OL EDB.4.0;Da ta Source=" & qStrSQL(gcConfig.CounterLo g) & ";Extended Properties=""Text;HDR=No;F MT=Delimit ed\"""
but it doesnt seem to like it :o(
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.OL
but it doesnt seem to like it :o(
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.