Copy WORD to ACCESS?

[mud2]

I "copy" a table from a financial page to WORD. How do I copy this WORD table to Access?
I CAN!! get it to EXCEL....

[waysofolde]

First, you have to save the document in word as either a Rich Text Format or text file.

Then, you have to open Access.

Once access is open, either create a new database or open an existing one.

Once that is done, go to File, Get External Data - Import.

Once it opens up the open file, click on the bottom where it says Files of Type, Click on Text Files and then select the document that you want to import. Access should open up a wizard from there to help you out.

Hope this helps.

[Tommy]

Hi mud2, :hi:
I have a knowledge base submition here: http://vbaexpress.com/kb/getarticle.php?kb_id=243 . It exports a work table(s) to a csv file and imports that into an access database, or it could be used to import into excel with a few modifications. :thumb