Re: How to load a MS Word document into a Text field

> I am trying to load a Word document into the Informix text field. From what I > have read and understood this is one of the purposes of the text field. I am > using the UNIX operating system of Informix. > I tried using the load command and I keep getting errors. > Has anyone done this? > Also when using the load command, is there any way to load a file from your > hard drive to Informix without having to FTP it to the Informix Unix server > first? > Teresa Tindell > Florida Department of Health Care Administration Are you trying to store the file with all of the Word control/formatting characters included (i.e., in *.DOC form)? If so, TEXT will not work with the load command from within DB-Access. You have to use BYTE fields. TEXT fields can only have printable ASCII text or tabs, unless you use a program and place the non-printable data into a host variable. Check the Informix Guide to SQL: Reference (http://www.informix.com/answers/english/pdf_docs/gn7382/4365.pdf), pg. 2-24 "Non-printable characters with TEXT". Mark Collins mcollins@us.dhl.com