[AccessD] Get data from Word Doc - A2K

Bert-Jan Brinkhuis thevigil at kabelfoon.nl
Tue Apr 13 03:02:13 CDT 2004


Reuben,

just a thought: isn't it possible to save the word document as a txt file
and open that in access an scan line by line? If the line's have specific
word's it must be possible to find them. Or maybe you know which linenumbers
you want to scan?

Bert-Jan

----- Original Message ----- 
From: "Reuben Cummings" <reuben at gfconsultants.com>
To: "AccessD" <accessd at databaseadvisors.com>
Sent: Monday, April 12, 2004 11:40 PM
Subject: [AccessD] Get data from Word Doc - A2K


> I have a 393 page Word document that has data about bridges.  Every 3
pages
> is one bridge meaning every third page is formatted exactly alike (Page 1
> and Page 4 are alike, Page 2 and Page 5, Page 3 and 6).   There are about
10
> pieces of data I would like to extract about every bridge, a little bit on
> each of the three pages.
>
> Is it possible to scan thru this document somehow and 'extract' these 10
> items from it to Access?
>
> I have tried to copy the document to Excel, but a lot of the text from
Word
> will end up in one cell rather than split into a cell of its own.
>
> Thanks.
>
> Reuben Cummings
> GFC, LLC
> phone: 812.523.1017
> email: reuben at gfconsultants.com
>
>
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com




More information about the AccessD mailing list