Hello All,
I would like some initial guidance on a problem involving insanely large numbers of word files (can be converted if necessary!).
I have 60,000 word files (unfortunately) and I would like to extract a little information from these into Access like Site Number, Location, Date (in longhand i.e not 31/12/2007), these files are all in the same location and are named and numbered consecutively 1-60,000.
The intention is to use this minimal information to create a kind of index to the files so that users can search by criteria and locate a list of files that match and then from access open the file from access (this bit I have got the code for and works perfectly).
What I need to know is if it is possible to open the file, then read specific information and extract this into the database and set the value in one field to log the task as completed, all from within access? i do not need to process all 60,000 at once may be just in batches of 250-500 for each project.
Is what I am asking beyond the limitations of the programme? Unfortunately it is beyond mine! I have looked at off the shelf products but informaion is not always in the same position within the document, I would need to search for specific terms in the text such as date, location and extract the following information. The good news is the documents do follow a similar format and the information required does always follow on a seperate line.
At this stage all I hope to get is a little guidance so I know what kind of task is in store for me.
Thank You in advance,
Happy New Year to all.
John
I would like some initial guidance on a problem involving insanely large numbers of word files (can be converted if necessary!).
I have 60,000 word files (unfortunately) and I would like to extract a little information from these into Access like Site Number, Location, Date (in longhand i.e not 31/12/2007), these files are all in the same location and are named and numbered consecutively 1-60,000.
The intention is to use this minimal information to create a kind of index to the files so that users can search by criteria and locate a list of files that match and then from access open the file from access (this bit I have got the code for and works perfectly).
What I need to know is if it is possible to open the file, then read specific information and extract this into the database and set the value in one field to log the task as completed, all from within access? i do not need to process all 60,000 at once may be just in batches of 250-500 for each project.
Is what I am asking beyond the limitations of the programme? Unfortunately it is beyond mine! I have looked at off the shelf products but informaion is not always in the same position within the document, I would need to search for specific terms in the text such as date, location and extract the following information. The good news is the documents do follow a similar format and the information required does always follow on a seperate line.
At this stage all I hope to get is a little guidance so I know what kind of task is in store for me.
Thank You in advance,
Happy New Year to all.
John
