Automate Converting Query To Pass-Through

  • Thread starter Thread starter Brian Kudera
  • Start date Start date
B

Brian Kudera

I'm wondering if anyone has some code that they have come across that takes
an MS Access query and converts it to a passthrough query automatically.

Ideally it would replace the underscores in the schema/table names in the
FROM clause and add an alias and replace the table names in the
SELECT/WHERE/GROUP BY/HAVING/ORDER BY clauses with the aliases.

It would also convert IIF statements to CASE statements, delete the # around
the dates, etc.

Thanks
 
Hi,
you can try to find it in internet, but not sure you find something really
working. I am not sure you can automatically make such conversion either,
from my experience only simple queries can be easy converted, other you have
to rewrite to get better result.

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
Back
Top