Word -> Access

[Rydel]

I don't know if that's the right place for this question. I have a task: a Word file with lines like:

http://WWW XXX

YYY, ZZZZZZZZZZZZ CR

http://WWW XXX

YYY, ZZZZZZZZZZZZ CR

http://WWW XXX

YYY, ZZZZZZZZZZZZ CR

I would like to take the respective data: first word (

http://WWW),

second word (XXX), etc. from MS Word and store it as a new record in an Access table.

I guess, that should be pretty basic stuff. But I haven't worked with this before. And don't feel like re-inventing the wheel. Big thanks in advance!!


regards,
rydel n23

http://pravapis.org/

http://rydel.net/

 

[BNPMike]

First try cutting-and-pasting straight into a table. If that doesn't work, cut and paste into Wordpad and then read that into Access as a text file.

 

[Rydel]

I wish it were so straight-forward. Let me explain. A paragraph corresponds to one record in a db. Each paragraph has the same structure (hopefully, because it's 300+ pages, I didn't check all of it) that looks like this:

[last_name] [space] [first name] [space] [some id number] [comma] [a lot of text with all kinds of punctuation until carriage return #13]

And I need to grab it to last_name, first_name, id, description, respectively.

But grabbing the text in VBA is not an issue (I think I can solve it). The issue is how you connect to DB in Word and add records. I know about ADO and DAO, but I can't find a working Word->Access example.



regards,
rydel n23

http://pravapis.org/

http://rydel.net/