Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS ACCESS Database and Word Templates
- Thread starter kishore22
- Start date
Better give more information than that.
What are the Word templates like?
Are they forms with formfields?
Is the data you need to extract in the same location in every file or could it be in one of two different locations in every file or is every single file different? What is the SAME about these Word templates? That would be the only way to automate it really. For instance, if you're trying to grab text that appears after "Name:" or "Company", etc, then that type of thing can be done. But if there is nothing the same about the Word files, I have no idea how you would do it.
Anne Troy
What are the Word templates like?
Are they forms with formfields?
Is the data you need to extract in the same location in every file or could it be in one of two different locations in every file or is every single file different? What is the SAME about these Word templates? That would be the only way to automate it really. For instance, if you're trying to grab text that appears after "Name:" or "Company", etc, then that type of thing can be done. But if there is nothing the same about the Word files, I have no idea how you would do it.
Anne Troy
- Thread starter
- #3
kishore22,
If the information isn't all the same, then I'm assuming your Access tables aren't all the same either - or where you hoping to make the Access tables from the imported information?
There isn't an automated manner to retrieving the data that I can see with such a variety, and based on the information provided.
Sorry.
C *~*~*~*~*~*~*~*~*~*~*~*~*
Insanity is a matter of Perception.![[yinyang]](/data/assets/smilies/yinyang.gif "[yinyang] [yinyang]")
If the information isn't all the same, then I'm assuming your Access tables aren't all the same either - or where you hoping to make the Access tables from the imported information?
There isn't an automated manner to retrieving the data that I can see with such a variety, and based on the information provided.
Sorry.
C *~*~*~*~*~*~*~*~*~*~*~*~*
Insanity is a matter of Perception.
If this is a must...then perhaps you can start here:
Have one of our friendly neighborhood coders here create a macro that finds each table in your document, and copy it to an Excel sheet. 5 tables = 5 worksheets. Name the Excel file the same as the doc.
Run this code on each Word doc (or maybe they'll be nice enough to write the code so it loops through all Word files in Directory names XYZ and writes each one to an Excel file).
Now...someone--and I'm thinking it's you, will have to go through each Excel file and start moving columns around to *standardize* the data. Either that or you'll have to get some REALLY extensive code to do that for you.
I assume some of the data is expendable if not all the docs have them...etc. Anne Troy
Have one of our friendly neighborhood coders here create a macro that finds each table in your document, and copy it to an Excel sheet. 5 tables = 5 worksheets. Name the Excel file the same as the doc.
Run this code on each Word doc (or maybe they'll be nice enough to write the code so it loops through all Word files in Directory names XYZ and writes each one to an Excel file).
Now...someone--and I'm thinking it's you, will have to go through each Excel file and start moving columns around to *standardize* the data. Either that or you'll have to get some REALLY extensive code to do that for you.
I assume some of the data is expendable if not all the docs have them...etc. Anne Troy
For the amount of work it would take to convert to Excel and move columns to standardize the files as much as possible, you could probably just manually grab the Word tables and import them in to Access anyway.
It would definitely help to have more information on the tables and what's going in to Access. For instance, if the need is for only certain data to get in to Access out of everything THEN some kind of code would probably be great to look for that data. BUT, if it's just to dump everything in to Access, what's the point? The desired end result? Knowing that might help generate other thoughts on how to handle the situation.
C
*~*~*~*~*~*~*~*~*~*~*~*~*
Insanity is a matter of Perception.
It would definitely help to have more information on the tables and what's going in to Access. For instance, if the need is for only certain data to get in to Access out of everything THEN some kind of code would probably be great to look for that data. BUT, if it's just to dump everything in to Access, what's the point? The desired end result? Knowing that might help generate other thoughts on how to handle the situation.
C
*~*~*~*~*~*~*~*~*~*~*~*~*
Insanity is a matter of Perception.
- Status
Similar threads
- Locked
- Question
