Avatar of SteveL13
Flag for United States of America asked on

How convert Word table to Access table

I have a Word document that has a table that looks like:

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.

Microsoft AccessVBA

Avatar of undefined
Last Comment
Helen Feddema

8/22/2022 - Mon
Benjamin Voglar

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

Ryan Chong

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?

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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

This will be a one-time import.
Helen Feddema

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question