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

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
>
>
>

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
> >
> >
> >