Connect Word Doc to SQL

[jymm]

ok - I KNOW that I have done this before, but I am in a new environment without the fun tools of the old job.

Have a word 2000 document that I want to have a user enter a parameter and then have MS Query (or similar) go out to a SQL 2000 view or table and bring back a few fields for the word document.

driving me NUTS that I can not remember or can not find that one important piece that I am missing

anyone here got the solution handy?

 

[01Patrik]

Take a look at faq707-5844 in the VBA forum. You'll need to adjust to Word of course, as well as adjust the connection string, but the basics about ADO and recordsets apply.



// Patrik
______________________________

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the IT Professional, the glass is twice as big as it needs to be.