View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Manoj Nair Manoj Nair is offline
external usenet poster
 
Posts: 1
Default 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