>Our system is uses a control, that allows for the data to be exported to HTML. I need to store the HTML document in the database once it is produced. I have a table called NoteCab with a field called NoteData which is a text field. I thought I could just use the:
>
>lcDataToStore=FileToStr('myDocument.HTM')
>
>and insert that. But because the HTML document has quotation marks and such, it fails on the insert. Is there a way to store the actual document into the database. We can't just have a file pointer stored, we have to have the actual document.
>
>Thanks for any pointers
>
>Kirk

What is your exact insert statement?
BTW I think you should post this question in VFP forum not in SQL Server one :-)