Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a connection string? | Excel Discussion (Misc queries) | |||
Connection to Excel from .Net using Oledb | Excel Programming | |||
Excel OLEDB format problem... | Excel Programming | |||
Define OLEDB connection string | Excel Programming | |||
What is the connection string ? | Excel Programming |