How convert Word table to Access table

SteveL13
SteveL13 used Ask the Experts™
on
I have a Word document that has a table that looks like:

Table-Example.bmp
or at least I think its a table (I'm not a Word expert).

How can I convert this to a table in Access.  There are approx. 100 fields in total and I don't want to hand create the fields if I don't have to.

--Steve
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2015

Commented:
Select the Word table and go to  Table/Convert Table to Text
Use the Separate the Text using Tabs option
Go to  File/Save As  and change the Save as Type to “Text only”. Save and close the file.
Open your Access database (create a new one if needed)
Right-click an empty area of the Tables Object list and select Import
Change the Files of Type to Text Files
Select your text file you saved earlier and work through the Import Text Wizard

http://word.mvps.org/faqs/tblsfldsfms/WordToAccess.htm
Ryan ChongSoftware Team Lead

Commented:
Do you have a sample word doc to upload so that we can try to import it into Access database?

Also, pls provide the table design so that we know how to map the values in Word to Access. What ver of Access are you using?
Distinguished Expert 2017

Commented:
The technique you need to use depends on whether this is a one time import or something that must be automated.  If it must be automated, we need to know more and you will probably have to add Word to the topics since we may need a Word expert to help with the VBA to extract the table from the document.  Although, I have had a fair amount of success with using the macro recorder in both Word and Excel to capture the code required for various types of automation.

Author

Commented:
This will be a one-time import.
Top Expert 2009
Commented:
That table does not seem to be the usual set of columns.  It has cells arranged differently on different rows (you can do that in Word).  I think you will have to write code to navigate the table cell by cell, importing data into a previously created Access table.  If the table was the usual type, you could just copy and paste it into a new Access table, but I don't think that would work here.

I have a code sample illustrating exporting data from a Word table into Access (it is old, but probably still works):

http://www.helenfeddema.com/Files/code8.zip

This code has been considerably updated, and the new version is one of the examples of data exchange between Word and Access in my ebook, Working with Word -- the 4th edition is available from Office Watch.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial