Migrating SQL Query Statements from one db to another

A

AnotherMcGyver

I have a datawarehouse application that updates "linked tables" into
MS-Access, so users can make SQL queries using MS-Access as a Proxy.

In deploying some Cognos applications, I would like to take a selection
of MS-Access queries and export the SQL statements into a file.

This way, I can go to the "production" environment and deploy my SQL
code there. The datawarehouse already has the option of updating linked
tables.

If I package the .mdb file itself, I need to do a lot of work in
cleaning it up first (remove all linked tables), remove unnecessary
queries, whereas the "production system" has other queries and tables
already in it -- not really an option.

Any help?

-Alex
 
M

[MVP] S.Clark

Using VBA, you can extract the SQL property from each of the desired
querydefs.

See the help file for QueryDefs for some sample code.
 

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

query links to SQL server and mdb table 1
Linked MS SQL Server Tables 3
SQL query 1
How do I execute multiple SQL statements in Access?? 3
SQL to export query into table 1
Update table with values from another table 2
Update Table Field Value with SQL Query 2
Query not working for SQL Server 2

Top