I am trying to get a procedure to insert blob information into a sql server table. I can get a small text file to insert but when I try an xl file ( or something else) I get a type mismatch from the sp that I have created. I have read the file to a memory varialbe (filetostr()) and passed that to the stored procedure. Is VFP 9 truncating the value that is being passed or do I need to try a different approach to inserting the information in SQL other than an INSERT statement?

Thanks in advance
Kelly