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



"Brian Kudera" <(E-Mail Removed)> wrote in message
news:C3FEFE8E-665E-4A54-8966-(E-Mail Removed)...
> 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

You might look at the upscale wizard that converted MS Access to SQL server.

Brian Kudera <(E-Mail Removed)> wrote:

>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