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.
--
Peter Jamieson
MS Word MVP
> 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)?