importing table contents from Word 2007 into Access 2007 andgenerating queries, reports using Access

  • Thread starter Thread starter g_1
  • Start date Start date
G

g_1

I have 50 word documents in Word 2007 format. The data in the word
files is in a table of two columns and 10 rows consisting of
paragraphs which is basically a report how a unit in our company has
done for a given year for various parameters. I have such documents
for the past three years so I have 150 such word documents.

I have to analyze how each unit has progressed from the past year and
be able to generate a graph and some queries for that.

I will clarify with an example. I have a MS-Word 2007 File1.docx. It
has data in a table having 2 columns and 10 rows

First row of table(the text "First row of table" is not present in
the file)

Column 1 of table(the text "Column 1 of table" is not present in the
file)
Staff Turnover, Reasons for it

Column 2 of table(this text "Column 2 of table " is not present in
the file)

It is nearly 3% for
this year 2006. It occurred due to difference in pay
and how we can avoid it they were offered
here and other positions they found, less upscale
movement
and career growth. We will provide more training classes for
them to retain them and so on.

Similarly, Second row

Third row
 
There is no doubt that it is possible to write some code that would iterate
through all of the documents in a folder and extract the information from
tables in those documents and insert it into a table in an Access database.

Whether you can create the necessary code yourself would depend upon your
knowledge of VBA. However, you will find some information that may help you
get started at

http://gregmaxey.mvps.org/Extract_Form_Data.htm

and possibly

http://gregmaxey.mvps.org/Extract_Document_Data.htm


--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.
 
Doug said:
There is no doubt that it is possible to write some code that would iterate
through all of the documents in a folder and extract the information from
tables in those documents and insert it into a table in an Access database.

Whether you can create the necessary code yourself would depend upon your
knowledge of VBA. However, you will find some information that may help you
get started at

http://gregmaxey.mvps.org/Extract_Form_Data.htm

and possibly

http://gregmaxey.mvps.org/Extract_Document_Data.htm
Click to expand...

The link is really helpful. But, is there any other way, I can just
save the Word 2007 files as some format and then import them
into Access 2007. I have not used VBA before and the short time
constraint does not allow me to learn it for this task.

What sort of formats does Word 2007 support which can be
imported properly in Access 2007. I tried Open Xml which did
not work.
 
Try copying each table and pasting it into Excel. You should then be able
to copy the information from Excel and Paste it into Access as a table.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.
 
Back
Top