Separate word pages for import/export

[PSLondon]

I have a collection of word documents that I would like to import int a spreadsheet or database as one record/row for each page in the word document.

Is this possible at all?

 

[EndoMan]

To put this simply, there is no "easy" way to do this. With some VB programming you could probably accomplish this but it will require a lot of trial and error. The biggest variable in the problem is probably the layout of the Word documents. If it contains verbage you don't want to import, you need to develop coding that would help it identify which words you DO want.

However, if the Word documents were created using Form Fields (i.e., text boxes), the coding is a bit easier because the "bookmarks" for the text boxes can be used to reference the desired text.

About two years ago I developed a similar program for an individual who needed to import information from Word "forms" into an Access database. Basically I extracted the Word data into a comma-delimited text (.txt) file which I used for importing. It took me hours of trial and error to reach a workable solution.

 

[PSLondon]

Thanks for the advice. Did you use VB to extract the CSV text file?

I thought that this may be the route I'd have to go but hoped there may be an easy way I'd missed.

Each page is the same (pupil school reports) and all text is relevant so I think I'll get on with the extraction programming. (I might post a note on the VB forum to see if anyone has any good ideas on this)