Not exactly sure what you want to do, but perhaps

http://www.erlandsendata.no/english/...php?t=envbadac

http://support.microsoft.com/default...b;en-us;257819
How To Use ADO with Excel Data from Visual Basic or VBA

will be of some help.

--
Regards,
Tom Ogilvy


"Michael Kintner" wrote:

Does anybody have a Data Query on the fly example?

I would like to query a Microsoft Access database and stuff the results into
a new table. Can anybody help? I have used the External Data Function but
would like to customize the SQL with data from the XLS sheet to return
different results.

Thank you in Advance,
Mike