in reply to Retrieve data from MS Access which has Columns with OLE Object
From what you are saying, you are retrieving a copy of an object from the database which would be a binary word doc object( or it could be some other VBA Object?). If you wanted to retrieve the text from that object, then you could try to operate on that object with a OLE method it would understand. You may have to first create another OLE word object and then set it equal to the object you retrieve from the database and then grab the text using OLE. As it is, I would expect it to garbled, it is an object and not text.
JamesNC
|