I am trying to write a script (VBA) to mass update an existing table with a Blob field of Word Documents. I have the code setup to compare the document's last update date with the one in the table (a field for last date), then if the dates do not match, copy the document and insert it into the Blob Field. I have tried to copy the document as a OLE embedded source into a unbounded Object Frame, then copy this to the clipboard then paste to a Bound Object Frame. Finally, I set the field equal to the Bound Object Frame. Unfortunately, this doesn't work very well. Any suggestions?

What is a "blob" field?

You can do these three things:

1. Store all the text from the Word Doc in Access (memo field)
2. Store a link to a Word doc and open it from Access (hyperlink field)
3. Store an image of the Word doc in Access (OLE object)

I don't think you can store an actual Word doc within Access.

I could help with any of the three above, but not with the request as it is.

mmcdonal

A BLOB field is a Binary field in Access (OLE Object). To manually insert a Word Document into this field, you copy the Document from Explorer, then highlight the binary field and paste it in. I want to do this programmically.

I've never heard of a BLOB field, but I'm open to new ideas. The best that I can suggest is to cut & paste into a richtext field. A richtext field; though, does not have the full formatting capacity of a word processor like MS Word. If you're interested, I have more information on richtext fields.

PC

Hi

I am new to this forum and while browsing I noticed this reply to a question on inserting Word docs into Access. I have been trying to do this for an employees database I am developing. I would like to display CV's from Word in my database and, if possible, search them for specific skills or experience. I would love to know how to store the text in a memo field and any other hints you might have.

Thanks in advance.



Riccardo