OLE Object word to text

T

tom

I have an access table with a column of type "OLE Object"

inside this column are word documents so when i click on them , word
opens and i can edit them.

how would i go about converting the content of column to text instead ?
 
T

tom

i have added a little procedure like this:

Dim MyDB As DAO.Database, MyRec As DAO.Recordset
Set MyDB = CurrentDb
Set MyRec = MyDB.OpenRecordset("Select wordDoc_column From tbl_items")
While Not MyRec.EOF ' Loop trough the table
Dim wordDoc As Word.Document
Set wordDoc = MyRec![wordDoc_column]
MsgBox wordDoc.Content.Text
Wend

but the
Set wordDoc = MyRec![wordDoc_column]
comes back with a 'type mismatch' error

any ideas would be welcome
thanks,
tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLE Object Data Type Question 8
OLE Objects 2
Linked OLE Object 3
Access 2007 Database - OLE / ACE 2
OLE object 1
OLE Object Linking 1
Operation on the OLE Object Failed 2
Operation of OLE Object Failed 1

Top