Hi!
Well, there is no direct way to do this by using ADO. With ADO, you will require first to create a special routine to convert General field into the memo field. Then, keep in mingd that binary data on SQL Server could be stored ok opnly in the field of Image type. Image field is represented by very special way in ADO object - you cannot work with it by usual way as, for example, with Character field.
Tips related to all above you will find in following FAQ article:
FAQ#7995
>I am looking for some referance on how to .AddNew and .Update to a General Field, I am attemping to save Pictures, Wave files in a VFP DBC/DBF from VB6
>using a SQL Ststement, and ADO
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.