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.
--Steve
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
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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
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?
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.
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.
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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial