How to convert a MS Word table (.doc) to MS Access?

[yunyunliang]

I am trying to convert my tables in .doc files into MS ACCESS. Does anybody know a way to do that? Thanks

 

[kbanes]

I don't do this often, so there might be a better way, but I have found that I have the least amount of problems if I convert the table to text, with the columns separated by tabs, save the file as a .txt file (as opposed to a .doc) and import it into Access. Access (using a wizard) will do most everything for you. Its pretty easy.

Good luck

 

[yunyunliang]

Thank you very much for the help.

 

[rosalindr]

I've done this frequently. Convert the word table to a csv (comma separated value) file. You can do this by selecting the table, then from the main menu select Table|Convert|Table to Text and in the popup window select other and put a , in the little box. Save the output file as mydoc.txt.

Open Access. Add a new table. Select Import from the New Table popup window. In Files of Type, select Text Files. Locate the file you just saved as mydoc.txt and import it. The Import Text window will open. Select "Delimited" and click Next. The wizard will put your data into fields either named from your table headings, or named by Access. If these look OK, click Finish. If they don't, you can continue through the wizard to clean up the data, or go back to your original table and clean it up there first and reconvert it again.

Roz

http://www.mytrainingdept.com

 

[pitak3]

This all works if Word table doesn't have paragraphs inside the cells. If it does, what do I do? Thanks.