MS Word to MS Access

  • Thread starter Thread starter GCKing240259
  • Start date Start date
Depending on the size of the Word documents and the number of Word documents
you want to import, you may want to consider using either a text or hyperlink
field in your table to link to the documents' locations. It could be
possible, again depending on the size and number of documents, that you could
blow the Access 2Gig file size limit.

If this is something you need to do, you can use Automation to open an
instance of Word, open the document, select the document's text and populate
your memo field. I can't really help with the details, because I am not that
familiar with the Word object model.
 
thanks for that......I think text is limited to about 200 odd chararcters and
some of my tables are a little large. Hyperlink may be the way forward.

thanks again

Graham
 
Access table text fields are limited to 255 characters. Memo fields are not,
but you still face the 2Gig limit of the mdb.
 
Back
Top