I am a SQL Server DBA that has a client using FoxPro v8. When the client
imports CSV text with character fields delimited with double-quotes, they
have random records shift from time to time for no apparent reason. The
source records are clean meaning they do not contain commas or double-quotes.
Ironically, the same CSV text file imports into SQL Server, ACCESS and other
databases without any issues. Has anyone else run into this type of
strangeness? How did you resolve it?

Thanks!

Re: Strange issue importing text file by Cindy

Cindy
Fri May 06 17:29:26 CDT 2005

Hi Jen,

Any chance you could send me a file or part of a file that exhibits this
behavior? I could take a look at it.

--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


"Jen" <Jen@discussions.microsoft.com> wrote in message
news:082E6330-0153-462D-928E-83E48BF04653@microsoft.com...
>I am a SQL Server DBA that has a client using FoxPro v8. When the client
> imports CSV text with character fields delimited with double-quotes, they
> have random records shift from time to time for no apparent reason. The
> source records are clean meaning they do not contain commas or
> double-quotes.
> Ironically, the same CSV text file imports into SQL Server, ACCESS and
> other
> databases without any issues. Has anyone else run into this type of
> strangeness? How did you resolve it?
>
> Thanks!



Re: Strange issue importing text file by Jen

Jen
Fri May 06 19:17:01 CDT 2005

Cindy- I sent you an email with the link. I'm also trying some other
databases to see if is is only a FoxPro thing or if any others have issues.
I'll report those results when completed. Intrigued...

Thanks.
Jen

"Cindy Winegarden" wrote:

> Hi Jen,
>
> Any chance you could send me a file or part of a file that exhibits this
> behavior? I could take a look at it.
>
> --
> Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
> cindy_winegarden@msn.com www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
>
> "Jen" <Jen@discussions.microsoft.com> wrote in message
> news:082E6330-0153-462D-928E-83E48BF04653@microsoft.com...
> >I am a SQL Server DBA that has a client using FoxPro v8. When the client
> > imports CSV text with character fields delimited with double-quotes, they
> > have random records shift from time to time for no apparent reason. The
> > source records are clean meaning they do not contain commas or
> > double-quotes.
> > Ironically, the same CSV text file imports into SQL Server, ACCESS and
> > other
> > databases without any issues. Has anyone else run into this type of
> > strangeness? How did you resolve it?
> >
> > Thanks!
>
>
>

Re: Strange issue importing text file by Cindy

Cindy
Mon May 09 06:54:12 CDT 2005

For the record, I looked through Jen's file (names and addresses) and found
one row where there was an embedded Chr(13) in the address. I assume there
were others also.

--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


"Jen" <Jen@discussions.microsoft.com> wrote in message
news:1B24380B-B8F9-478B-9DD6-20830F32B162@microsoft.com...
> Cindy- I sent you an email with the link. I'm also trying some other
> databases to see if is is only a FoxPro thing or if any others have
> issues.
> I'll report those results when completed. Intrigued...

>> >I am a SQL Server DBA that has a client using FoxPro v8. When the
>> >client
>> > imports CSV text with character fields delimited with double-quotes,
>> > they
>> > have random records shift from time to time for no apparent reason.
>> > The
>> > source records are clean meaning they do not contain commas or
>> > double-quotes.
>> > Ironically, the same CSV text file imports into SQL Server, ACCESS and
>> > other
>> > databases without any issues.