I have not tried this, but could you use the Base64Encode and Base64Decode to convert the file to a text string, and store in an SQL column that way?
Should work, but will require a fair amount of scripting to achieve smooth process though.
I agree with Orlando, Base64Encode and Base64Decode are the easiest solution even with extra work.
An alternative to explore is to try to nsert into a Binary column, but you will need to get your file in binary first and I am not sure how well it will work with filemaker ESS
Still thinking about it - VBS should be able to read it as binary and I would try to set the column in FileMaker from VBS.
thanks, seems base64 will be an option. a binary column won't work I'm afraid. Fm just ignores it in the table list.
thanks and I just noticed a spelling error on original post.