How convert Word table to Access table

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
SteveL13Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Benjamin VoglarIT ProCommented:
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
0
Ryan ChongCommented:
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?
0
PatHartmanCommented:
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.
0
SteveL13Author Commented:
This will be a one-time import.
0
Helen FeddemaCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.