vba for word with sql help

[vbasqlhelp]

Hi, I need help with accessing data from an SQL server and putting it into word. Basically, I need to go through the records and print them to a word document. However, there are a varying amount of records, so there must be a loop of some sort that executes based on how many entries there are for that specific field.

Thanks!

 

[bartrein]

The steps to take would be as follows :
- download data into excel (using ADO recordset object and SQL query)
example code :

http://www.ozgrid.com/forum/showthread.php?t=83016

- create a word document (you can do it from excel as well)

http://exceltip.com/st/Control_Word_from_Excel_using_VBA_in_Microsoft_Excel/465.html

- run a loop to return your data to word

hope it helps

 

[CaptainD]

The way you asked for help leaves the answer pretty open. From Word I use a connection "Function" component in a module that returns an ADO recordset(s)

Once I retireve my data I place it in tables.

In my case I use a form that is called when the document opens (Or can be called from a Macro) to get some basic information and from there run my subs via a command click event.

What "Event" needs to happen to get the data and once you have it, how do you want to display it etc ?

 

[bartrein]

From Word I use a connection "Function"" - of course -
ignore my comment about excel you don't need it for your task Word will do the trick as CaptainD suggests.