Obtaining SQL Records using Word Macro

[Jon James]

I need to write a macro that will query an SQL table and return a small number of records (no more than 10-15) into an array. Something like

Dim strConnection As Strin
strConnection = "C:\Bills\NTSERVER OrderData qryBills.odc
qstrString = "SELECT ClientCode, ClientName, MatterCode, Description, BillNo, Narrative, OSAmount FROM strConnection WHERE ClientCode = B0002 ORDER BY Narrative ASC
The client code 'B0002' will be a varable that the document will have already picked up
I can't seem to make this work

 

[Jezebel]

Since ClientCode is a string, you need to put quotes around it:

"...WHERE ClientCode = '" & MyClient & "' ORDER BY ..."

You've also got special things to if you're working with dates or with
strings that might themselves contain quote characters.

I need to write a macro that will query an SQL table and return a small

number of records (no more than 10-15) into an array. Something like:

Dim strConnection As String
strConnection = "C:\Bills\NTSERVER OrderData qryBills.odc"
qstrString = "SELECT ClientCode, ClientName, MatterCode, Description,

BillNo, Narrative, OSAmount FROM strConnection WHERE ClientCode = B0002
ORDER BY Narrative ASC"