Hi guys,

I'm desperately trying to import data from a large numbers of word documents into a single excel file.

The data in the word documents is set out like this


DATE
Text Box____________________________________
|To:
| First Name Last Name
| ADDRESS
| ADDRESS
| ADDRESS
| POST CODE
____________________________________________


Then there is a similar box below this that contains exactly the same data on every sheet, basically just the return address.

what im wondering is if there is any way what so ever, to mass import all these files in to a single excel document. Eventually I want to use it in access, but i think an excel file is a necessary stop gap, unless theres a better way

Any help would be much appreciated

cheers
ali