Reading random record(s) into Word. Help!

[brianvic]

I would like to update fields in a Word document by using a macro to read a record from one or more MySQL tables. The required record is different for each document, but I would like to just use the one macro.

Using MS Query I can not set parameter values (not allowed) and without them it reads every record from the database. Within MS Query this is relatively fast, but within Word you can see it reading each record in. It's just too slow to be of use.

Does anyone know of any way in which Word can read a single record from a MySQL table. Which record is determined by the document name and isn't a problem, but getting word to just retrieve this record is. Any help would be greatly appreciated.

 

[sleipnir214]

You can do it in your SQL statement.

SELECT * from foo limit 1 Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!