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.