Reading CSV file into DataSet 1

[becks774]

Hello All,

I have this code that I am trying to read a CSV file into a Data Set. I have been researching this quite a bit and have tried the resolutions I have found.

If I se this code, the values that are not numeric do not get read into the dataset:

 con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + IO.Path.GetDirectoryName(strCurrent) + ";" + "Extended Properties=""Text;HDR=No;IMEX=1"""
                con.Open()
                cmd.Connection = con
                cmd.CommandText = "SELECT * FROM MPMCurrent1.csv"
                da.SelectCommand = cmd
                da.Fill(ds, "Actuals")

If I try this connection string, I get an " "Could not find installable ISAM."" error:

                  con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + IO.Path.GetDirectoryName(strCurrent) + ";" + "Extended Properties=""IMEX=1"""
                con.Open()
                cmd.Connection = con
                cmd.CommandText = "SELECT * FROM MPMCurrent1.csv"
                da.SelectCommand = cmd
                da.Fill(ds, "Actuals")

Please help.
Thank you!

 

[AlexCuse]

I believe if you have only numeric values in the first 8 rows, the column will be treated as a numeric datatype. Have you tried using a schema.ini file?

Have a look here:

http://www.connectionstrings.com/?carrier=textfile

Hope this helps,

Alex

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page

 

[becks774]

Thank you Alex! That worked!