Importing from table in word

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
 
K

Kate P

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!
 
C

Code Numpty

Have you tried using the Macro Recorder in Word to record these actions? This
would at least be a start.
 
Top