Adding data to the data source!

[Eduardo]

I have a word document with a header file(Merge fields),
and I have a disconnected recordset with the data for
those fields. What is the best way to get the data into
the document for later merging. Is there a way to past
data to the data source without actually being connected
to a database(using the disconnected recordset)?

 

[Peter Jamieson]

I don't know of any way to use a disconnected recordset directly as a data
source and am not convinced there would be a "best" way. You could fairly
easily create either a Word document containing a table (if there are no
more than 63 fields) using automation, or use (say) the Jet OLEDB provider
to create a .mdb and use that as the data source.