Re: Strange issue importing text file

Tech-Archive recommends: Fix windows errors by optimizing your registry

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@xxxxxxx www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


"Jen" <Jen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1B24380B-B8F9-478B-9DD6-20830F32B162@xxxxxxxxxxxxxxxx
> 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.


.

Relevant Pages

  • Re: Foxpro vs SQL Server
    ... you could make a sql server stored ... > I have to create a report in Crystal Reports off of a FoxPro database. ... With SQL Server I would create a view or stored procedure and base ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: Strategy Advise Sought!
    ... Large databases, well that depends on what "large" is. ... FoxPro is not a giga-sized database, like SQL Server, ... What kind of load can VFP take? ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Linking to ODBC in A2003 aborts
    ... It appears FoxPro had nothing to do with it. ... When I try to select either, it fails with an ODBC Error. ... They're recognized by A97 but then A97 has FoxPro in the "Files of type" dropdown. ... when I select "ODBC Databases " file types the datasource window isn't displayed...it simply returns to the database window as if the linking process is complete although no data source was selected. ...
    (comp.databases.ms-access)
  • Re: dos database and windows database
    ... a company having program of gvality control is consist of foxpro databases, ... between base of dos and windows datas. ... Access database to FoxPro tables, ...
    (microsoft.public.access.gettingstarted)
  • Re: Strange issue importing text file
    ... databases to see if is is only a FoxPro thing or if any others have issues. ... >> imports CSV text with character fields delimited with double-quotes, ... >> have random records shift from time to time for no apparent reason. ...
    (microsoft.public.fox.programmer.exchange)