Hi Jamie:

"Jamie Collins" wrote:

because the
source is a Jet (MS Access) database and the target (i.e. Excel) is
also a Jet datasource, it may be possible to take advantage of a few
tricks e.g. creating a JOIN between data in the .xls and .mdb can save
a lot of processing time and trouble parsing a delimited string of key
values from the client.

Jamie.


Not to say it has not been done, I have never seen a JOIN written like that
maybe you could share an example.

TK