Adding Word document references in a table

[reidarT]

I have a table with ID, textname and object.
The text should be c:\folder\1.doc
and the object-field should be an OLE-connection to the actual word document
I want to have a preview of the word document in the field object.
This works ok, when I manually enter (click) the path and filename of the
Word-document.
I need at least 1500 documents and wonder how to do this programatically
with the AddNew-method.
The documents have the name 1.doc, 2.doc, 3.doc ... where the docname is
equal to the ID.

regards
Reihaa

 

[Mike Painter]

I have a table with ID, textname and object.
The text should be c:\folder\1.doc
and the object-field should be an OLE-connection to the actual word
document I want to have a preview of the word document in the field
object. This works ok, when I manually enter (click) the path and filename
of
the Word-document.
I need at least 1500 documents and wonder how to do this
programatically with the AddNew-method.
The documents have the name 1.doc, 2.doc, 3.doc ... where the docname
is equal to the ID.

The Dir command in a loop can be used to pick up the full path and name of
the documents.
It's easiest if they are all in one folder.
I also put the path in the description field. It will not be much help here
but if the name has some meaning it is worth doing.