Extract data from Word doc (1 Viewer)

[Ron_dK]

I have a word doc from which I want to import data in a Database.
The word doc has a table, something like this :

Projectnumber 10700004
LSname LSTK number one
POnumber 1170-LST-04
Contactname Mr. Karel van Straten
Vendorname Mothercompany name S.A.
Manufacturer Operating Company name
Otherdata Others
Mancity 46100 Hamburg
Mancountry Germany
Manorder 31-0111-009
Mancontact Mrs. Angela Duval
Mantel 0049 2323 209 151
Manmail email@testing.de

At this stage I copy the table data and paste it into a memo field in a Dbase Query and try to manipulate the text in that query to get some of the data segregated , i.e Projectnumber : 10700004 , Mancountry : Germany , etc.
However, this doesn’t work as I want.

e.g. I’m trying to get the Manmail text thru this qry :
Manmail: Mid([Memofield],Len([Memofield])-InStr([Memofield]," ")) , but the output is not consistent.

Would there be a better way to get the original ( doc-table) data in the same way in my database.

Note :
I could use an additional step : copy/paste to Excel and then import to Access, but that’s something I would like to avoid.

Any suggestion will be appreciated.

Cheers, Ron

 

[BarryMK]

Ron did you find this thread? http://www.access-programmers.co.uk/forums/showthread.php?t=57072&highlight=import+word

 

[Ron_dK]

Yes, thanks for that Barry.

I have been playing with the (newer) example that Pat gave in her post,
but as the Doc said

Once you get the components figured out, extracting text from a Word Table is easy. Now getting the formatting data? That is harder because the formatting model is a LOT uglier. Don't ask. You don't want to know.

formatted data is a hell of a job. So I decided not to go in that direction.

Thanks anyway.

 

[Ron_dK]

Any idea's anyone ?

 

[PatrickJohnson]

easiest way for me was to load the data from the word table(s) in the document into arrays then parse that data into fields on a table. I did it with some help in this thread:
http://www.access-programmers.co.uk/forums/showthread.php?p=716286#post716286
Then you can play around with the data all you want