Automate Converting Query To Pass-Through

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
 
A

Alex Dybenko

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
 
S

Stewart Berman

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Passthrough Query Results to Local Table 2
Passing parameter from Query to vba 2
Pass query snapshot to report? 4
Pass through / ODBC Data Source 6
Question on Pass-through Query 4
Pass-Through query used to update an access table 2
Query through code 1
Pass through query to SQL Server 3

Top