This is the part that is not clear...I thought the text files contained data. Are you saying each text file contains an INSERT command?
>There is a Bug in Foxpro, If i use an insert query from another programs like VB or anything. It fails.
>
>You can also read the article:
>
http://www.webmasterworld.com/forum47/1873.htm>
>**************
>
>My problem is I am trying to upload the text files which i have.
>
>Each text file is 2k size more than 4000 chars in it. I am trying to upload the text5 file to a memo field in the table ocdata.
>
>When i fill my insert query with the text file data, the insert query is going to be in multiple lines, when the query is in multiple lines it is failing.
>
>You can also try on your machine:
>
>write an insert query with two lines in a note pad and copy and paste in the command window of VFP. You should see the error.
>
>Thanks.
Steve Gibson