Importing from table in word

  • Thread starter Thread starter Kate P
  • Start date Start date
K

Kate P

Hi,

I need to import the contents of a table in a word doc into access. There
will be multiple word docs that I need to import (all the same format) so I
want to automate it in Access. Any ideas?

Thanks
 
Kate P said:
Hi,

I need to import the contents of a table in a word doc into access. There
will be multiple word docs that I need to import (all the same format) so I
want to automate it in Access. Any ideas?

Thanks
Click to expand...

More specifically - At the moment I have to open the doc, select the table,
convert the table to text (comma seperated) and save as .txt. This is the bit
I have no idea how to automate.

Although if anyone knows a way of reading bits of tables into a database
automatically that would be better!
 
Have you tried using the Macro Recorder in Word to record these actions? This
would at least be a start.
 
Back
Top