Using word with sql sp 1

[junkmail]

I know you can call a SQL stored procedure from excel and have it populate cells but can you do the same with word? if so can some post a sample of exactly how to do that. Thanks in advance for you help.

 

[Andrzejek]

This is a VBA question so you should be asking it in forum707

But you can try this

one of the hints is here

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[SkipVought]

HI,

I assume that you are referring to MS Query in Excel where you can query databases, stored procedure or not, and return the resultset to the worksheet.

Seems a word processor and a spreadsheet are quite different tools. I suppose you could code ActiveX Data Objects in Word VBA, and then populate a Word Table.

Of course, you do have the MailMerge feature, but your db extension must be listed in the Select Data Source window.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[junkmail]

Will do! Thanks for the help.

 

[macropod]

Word has a DATABASE field you could use for this. For a demonstration, see:

http://www.msofficeforums.com/mail-merge/21847-mail-merge-into-different-coloumns.html#post67097

Cheers
Paul Edstein
[MS MVP - Word]

 

[SkipVought]

Woah, macropod. WTG!

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}