Hi,
thanks for reply.
See my header don't have comma in it. Sor in first row i am inserting
just garbage string like string containing only 'a' character 300
times. Means no comma at all.
Still i am facing problem.
can u tell me whether its related to encoding or realted to some
nonprintable chatacter, What i observer is file have lots of non-
pritable chatacter. I found one strange thing that is if i remove one
character by opening file in textpad every thing starts working
properly.
I am very much confused now.
Please help me asap.
thanks .
Marc Gravell - 13 Jul 2007 09:16 GMT
I still think "line endings"; it sounds like textpad is fixing the
line-endings when saving, which it only does it it thinks the data is
dirty (i.e. you have removed on character).
I don't know textpad, but I use "Programmers Notepad 2", which has an
option to view line endings. If textpad has something similar, turn it
on and loook at what you see. At the minimum, they should agree on
every line (i.e. "CRLF", "CR", or "LF" on every line). For best
results, they should match what your parser is expecting. But I don't
use OLEDB from .NET, so I don't know what it wants - the link I posted
will accept any suitable line ending.
Marc
Aaron - 13 Jul 2007 14:36 GMT
Still, you never answered my question. Is it breaking when your application
tries to read the file or is it breaking when you try to write to the file?
> Hi,
>
[quoted text clipped - 16 lines]
> Please help me asap.
> thanks .