[AccessD] Get data from Word Doc - A2K

Jim Lawrence (AccessD) accessd at shaw.ca
Tue Apr 13 09:54:18 CDT 2004


Hi Reuben:

Could the document be saved as a text file and then processed through
Access?

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Reuben
Cummings
Sent: Monday, April 12, 2004 2:40 PM
To: AccessD
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