Import text from file into one field

[lsmcal1984]

Hello,

I am looking to create a command button that enables users to browse to a text/Word document and then import the contents of that file into a Memo field.

Any help appreciated!

Thanks

 

[jdraw]

You might try using the filesystemobject and the readall method

some info at
http://www.techbookreport.com/tutorials/fso3.html

but google filesystemObject and vba

NOTE: I'm not sure what your objective is, but putting everything into 1 memo field is not usually a good strategy. Perhaps if we knew more about your ultimate use of the data in Access, more focused advice could be given.

good luck

 

[lsmcal1984]

Thanks for a quick response.
The data being imported is the original text of a letter/response received, which will have been scanned in by OCR.
I need to retain this information with the associated record so we don't keep hard copies. There will be no analysis on this data, just a report if needed.

 

[WineSnob]

Have you thought about using a hyperlink field to the actual document? That way you can easily access the document from the record.

 

[lsmcal1984]

The records to be imported are to be temporary Word documents, they won't be retained.