Data Query on the Fly
 

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

Data Query on the Fly
 

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

Data Query on the Fly
 

You can also make you External Data query dependent on cell values:

http://nickhodge.co.uk/gui/datamenu/...taexamples.htm

http://www.dicks-clicks.com/excel/Ex...htm#Parameters

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote:

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