Converting word documents to Access

[MM19542743]

Hello all,
I have read the forums and still have not been able to convert Word files correctly. I would like some assistance on the best way to convert word documents into access tables. These documents are large and have anywhere from 50 to 100 tables in each word doc. Any input would be greatly appreciated. Please see attached file.
Many thanks in advance.
Michael

 

[Dick7Access]

Hello all,
I have read the forums and still have not been able to convert Word files correctly. I would like some assistance on the best way to convert word documents into access tables. These documents are large and have anywhere from 50 to 100 tables in each word doc. Any input would be greatly appreciated. Please see attached file.
Many thanks in advance.
Michael

Not sure this is what you are looking for. I have never us this so check it out and see if it works for you.
http://www.techonthenet.com/access/modules/word_doc.php

 

[WLCummings]

Try cut and paste just the data into a excel file with nothing but the column headings on the page - no titles no notes - you even have to do this with excel files if they have anything but the actual table on the same page you are in porting.

 

[The_Doc_Man]

Overview:

In MS Word documents, if you are REALLY talking about tables in a document and all you want is to pull said tables out of the document, you can write some VBA to do nested enumerations.

You need to open a word document as an Access object called an application object, but it has to be declared as a WORD Application object. You can then open your document through methods associated with the Word object.

Once the file in question is open, tables are simple. In Word, a table is a member of the Tables collection. You can use a For Each loop to step through the tables.

Inside the loop implied by having a For Each Table construct, you can query each row for the chosen table with a For Each Row. Inside THAT loop, you can examine the individual columns. Here, I would have a recordset open so that you can do a direct deposit in each field of your target table.

The syntax might be complicated because inside the inner loop, assuming you do not use With clauses, you might be picking up something from WordApp.Table(i).Row(j).Column(k) for one field of your recordset. The syntax would look more or less just like that. The best part is that if you never merged rows or columns, your selection of a particular cell in any table in a Word document would be totally random-access (if you needed for it be that way.)