[AccessD] Get data from Word Doc - A2K

I'd second that approach and take the time to mention Seth Galitzer's often
utilized File I/O code snippets. http://puma.agron.ksu.edu/~sgsax/ 



Mark


-----Original Message-----
From: Bert-Jan Brinkhuis [mailto:thevigil at kabelfoon.nl] 
Sent: Tuesday, April 13, 2004 4:02 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Get data from Word Doc - A2K


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

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com