OLE Object word to text

  • Thread starter Thread starter tom
  • Start date Start date
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 ?
 
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
 
Back
Top