Queries and ODBC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone,

Is there a way to invoke an MS-Access query via ODBC?

Sorry if this is in the wrong thread.....

Kind Regards,
Pat.
 
Hi Everyone,

Is there a way to invoke an MS-Access query via ODBC?

Sorry if this is in the wrong thread.....

Kind Regards,
Pat.
Click to expand...

Use File... Get External Data... Link; choose ODBC as files of type; select
your ODBC service.

This gives you an Access linked table upon which you can build queries to your
heart's content.

John W. Vinson [MVP]
 
Thanks for that, John, but I'm still a bit lost - I'm working with some 3rd
party software that allows me to do a "Free SQL" - whatever I type will be
transmitted to the jet engine - So, from an external source, via ODBC, how
can I invoke an Access query.

Thanks again, John.
Pat.
 
Thanks for that, John, but I'm still a bit lost - I'm working with some 3rd
party software that allows me to do a "Free SQL" - whatever I type will be
transmitted to the jet engine - So, from an external source, via ODBC, how
can I invoke an Access query.
Click to expand...

That you'll have to ask the third party software provider. I really don't
know!

John W. Vinson [MVP]
 
Back
Top