Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pamela Thalacker
  Where is Pamela Thalacker?
 Terrebonne
 Oregon - United States
 Pamela Thalacker
 To: DEREK DODOO
  Where is DEREK DODOO?
 READING, UK
 United Kingdom
 DEREK DODOO
 Tags
Subject: RE: problem with text file generated
Thread ID: 143090 Message ID: 143099 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Friday, August 24, 2007 9:07:40 PM         
   


If you could identify the line in the text file where the importing application fails, that would be very helpful. You could go to that line see what it looks like. The odds are that a line termination character or something like that somewhere in your VFP data that causes the 3rd party to midread a row.

I feel certain that the problem is not with the COPY TO command, but it could easily be with the data in the dbf.

pamela

> I have opened the textfile, and the format is ok,
>
> There is no error generated whilst creating the textfile.
>
> It's when the textfile created is being imported to the 3rd party software, that this
> issue of format inconsistency stops the process.
>
> I've gone thru the text file line by line, and the length of each record is the same including the spaces at the end.
>
>
>
> > I don't have access to Marcia's crystal ball, but I am sure she would find it malfunctioning over this question. I think the content of the error message is crucial to a diagnosis of the problem.
> >
> > You know that you can open the SDF file in any text editor and see whether there is a problem with it?
> >
> > pamela
> >

ENTIRE THREAD

problem with text file generated- urgent Posted by DEREK DODOO @ 8/24/2007 7:40:55 PM
RE: problem with text file generated Posted by Pamela Thalacker @ 8/24/2007 7:47:45 PM
RE: problem with text file generated Posted by DEREK DODOO @ 8/24/2007 7:59:28 PM
RE: problem with text file generated Posted by Barbara Peisch @ 8/24/2007 8:34:06 PM
RE: problem with text file generated Posted by Pamela Thalacker @ 8/24/2007 9:07:40 PM
RE: problem with text file generated- urgent Posted by Borislav Borissov @ 8/24/2007 9:02:09 PM
RE: problem with text file generated- urgent Posted by DEREK DODOO @ 8/25/2007 6:21:19 AM
RE: problem with text file generated- urgent Posted by Borislav Borissov @ 8/25/2007 8:06:46 AM
RE: problem with text file generated- urgent Posted by DEREK DODOO @ 8/27/2007 3:22:22 PM
RE: problem with text file generated- urgent Posted by Borislav Borissov @ 8/27/2007 3:59:29 PM
RE: problem with text file generated- urgent Posted by tushar @ 8/27/2007 4:31:14 PM
RE: problem with text file generated- urgent Posted by tushar @ 8/25/2007 8:52:10 AM
RE: problem with text file generated- urgent Posted by Cetin Basoz @ 8/24/2007 9:28:50 PM