Copy text file to Memo Field

[HDobler]

I am looking for ideas on how to copy the text from a text file and insert the entire text of that file into a memo field.

I am working on a document retrieval database. Each document has a document number. I have a record in the database for each document with a document number field containing that unique document number. The text file containing the text of that document is named XXX.txt where XXX is the document number.

I need to some up with some type of routine that can be called with the document number and go open that file, read the entire file of text data and copy that data into the memo field which is named Text of Story.

To build on that would be something that can be batch run with a condition or query of Processing Stage <= 500. I have several steps involved and each step has a number. I only want to process this for entries that have not already been processed for this stage which is identified by a Process Stage less than the number of this step which for now say is 500

Thank you in advance for any suggestions or code snippets.

Harry

[orange]

Why does the text have to be stored in a memo field? Is that some mandatory instruction? This sounds a little bit like a home work assignment. Is it?

You could leave the full text on the file system, and record the folder and filename in your database.
And have the text presented when needed.

There are a number of free data models at http://www.databaseanswers.org/data_...all_models.htm

Some of these deal with Documents and document management.

good luck with your project.

[HDobler]

Maybe I am overthinking this or making it harder than it needs to be. Let me back up and explain from beginning in case I got off on wrong track.

I have documents that I receive from a coworker. These are either PDF or Word files. I need to be able to log these documents in an Access database and do 2 things with them. I need to be able to bring up the original document in its original form. I am currently doing this by creating a hyperlink the original file. I also have to be able to do a search for particular phrases or names in the documents. I tried but was unable to get Access to go out and read external files as part of a query even if they were text files. As a result for the search option, I added a memo field so that I was not limited on length of text. From each Word or PDF file, I am creating a text file of unformatted text. I am looking for a way to take those text files and add their text to the associated memo field. I have 1 record for each document. Each document has a number. The Word/PDF file and the .txt each are named by document number.

Any help would be greatly appreciated even if that help is telling me I went about his all wrong.

I also would like to be able to print a copy of the original Word/PDF file in a report if that is possible but I have not asked that question yet.

Harry

[HDobler]

Any suggestions would be greatly appreciated. If I posted in wrong forum and should post elsewhere, please of that also.

The short version of my question is suggestions on how to take a .TXT file, open it and copy the entire contents of that file into a memo field. More detailed information is listed above if needed.

Thank you in advance for any suggestions given.

[Wasser2021]

Hi folks, I have a similar problem, simple things are very complicated in VBA. Simply copying a variable into a data field is not intended. Where is the mistake ?

[Minty]

Hi folks, I have a similar problem, simple things are very complicated in VBA. Simply copying a variable into a data field is not intended. Where is the mistake ?

You have posted on the end of a 8 year old thread.
I would suggest starting a new thread with some examples of what you have tried and where you are getting an error.