[AccessD] Extract data from .doc into db

Michael,

Have a look at these topics

http://smsconsulting.spb.ru/shamil_s/topics/dfromw95.htm
http://smsconsulting.spb.ru/shamil_s/topics/w95imp.htm

they may help you to solve your task directly.

> Maybe export the tables to Excel?
Yes, you can also copy your MS Word tables into MS Excel worksheets, then
attach these worksheets etc.
For 240 docs if the work is just one go then I'd recommend to copy data into
MS Excel manually - should be doable in a couple of hours - no need in
coding...

If you copy your source tables' data into MS Excel worksheets then these
topics may help for further work:

http://smsconsulting.spb.ru/shamil_s/topics/impbcdb0.htm
http://smsconsulting.spb.ru/shamil_s/topics/impbcdbb.htm
http://smsconsulting.spb.ru/shamil_s/topics/rxltbl.htm
http://smsconsulting.spb.ru/shamil_s/topics/exobjpr.htm

http://smsconsulting.spb.ru/shamil_s/topics/expexcel.htm

Depending on the quality of the source docs' data your task could be done in
1.5 - 5 days I guess...

Shamil

----- Original Message ----- 
From: "Michael Maddison" <michael at ddisolutions.com.au>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, January 05, 2006 3:08 AM
Subject: [AccessD] Extract data from .doc into db


> Hi Listers,
>
> I've been asked how much $$$ to extract data from a series of word docs.
> Each record is made up
> of 3 docs.  There are 80 records (240 docs).  The docs are quite large
> 20+ pages each, with questions
> and either ticks or X's in a tabular format.  There are no fields.
> I've never done this so my question is how easy is it to code something
> like this or should I just
> employ a temp to slog through it?
>
> BTW it's a one off import.
>
> Maybe export the tables to Excel?
>
> cheers
>
> Michael Maddison
>
> DDI Solutions Pty Ltd
> michael at ddisolutions.com.au
> Bus: 0260400620
> Mob: 0412620497
> www.ddisolutions.com.au
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com