Update Oracle tables from Word document

[Colm]

Hi all,


Not used to using VBA at all but I want to know is it possible to update Oracle from data contained from mail merged letters.ie. I want to update back onto Oracle from the letters created and printed.


How do I start doing this. Any tips greatly appreciated.


Many thanks,

Colm

[Oorang]

Sure just use ADODB. I should warn you that while very doable, it is not trivial. There is an example of how to do this here (http://www.incredible.gr/caspdoc/Ch11_ADO141.html). You will need to change the connection string to the Oracle connection string, you can find a list of connection strings here (http://www.connectionstrings.com).

[Colm]

Thanks very much. I'll go about looking into this.

Colm

[Oorang]

If you run into trouble with implementation, post back:)