Raj,

In this message, you said that the command works fine. In the first message in the thread, you said that it doesn't. Can you explain what is happening a little more? Or am I confused? :)

>No, the date is not at all a problem, it works fine:
>
>you can try this by typing the whole insert query in 1 single line command window, it will work fine.
>*********************************************************
>Insert into ocrdata(id,tiffile,ocdata,created_dt) Values(7713,'demdemorecv10','Apartment lease THIS APART',{9/9/2004})
>*********************************************************
>the ocdata is a memo field in it i upload all the text file content.
>
>I have like more than 1.5 million text files, all the data of the text files i need to upload to foxpro memo field.
>
>So, when i finally fill all the values into my insert query on Visual Basic, My insert query will definetely become a multiline query.
>Something is really messing up.
>Thank you.