oledb connection string problem in vb.net
 

Hi,

When I load a csv file into a dataset with the column containing numeric
data the header name string does not show up .Where as if the data in the
column is alphanumeric or text then the heading appears.

I have tried the following connection strings
-------------------------
String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Da ta Source={0};Extended
Properties=""text;HDR=Yes;FMT=Delimited""",
Path.GetDirectoryName(mDataSource))

---------------------

String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Da ta Source={0};Extended
Properties=Text;", Path.GetDirectoryName(mDataSource))

----------------------------------

would appreciate help on this.

thanks is advance

Manoj