Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag 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:

User generated image
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
Avatar of Benjamin Voglar
Benjamin Voglar
Flag of Slovenia image

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
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.
Avatar of SteveL13

ASKER

This will be a one-time import.
ASKER CERTIFIED SOLUTION
Avatar of Helen Feddema
Helen Feddema
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial