Data Query on the Fly

[Michael Kintner]

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

 

[Guest]

Not exactly sure what you want to do, but perhaps

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

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

will be of some help.

 

[Guest]

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

http://nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm

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