ACCESS FEED: Re: [MS_AccessPros] Q: Utility to extract SQL from Access 2003

Senin, 27 April 2015

Re: [MS_AccessPros] Q: Utility to extract SQL from Access 2003

Crystal:

Thank you, this looks like it will do what I am looking for. I have over 2000 queries in Access, and our goal is to bring them into our Oracle data warehouse.

In MS Word, I can do many of the changes as a Find and Replace.

This will really move the project forward.

tnx,
Gary

At 08:21 PM 4/24/2015, Crystal strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:

adding on ...

here is some code to write all the SQL from all queries to a searchable Word document:

Document Query SQL, Form and Report RecordSource
http://www.rogersaccesslibrary.com/forum/document-query-sql-form-and-report-recordsources_topic606.html

Warm Regards,
Crystal

~ have an awesome day ~

On Friday, April 24, 2015 12:44 PM, "Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

BRILLIANT!

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [ mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, April 24, 2015 11:13 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Q: Utility to extract SQL from Access 2003

Gary-

You could export all the query SQL as a text file like this:

Dim db As DAO.Database, qdf As DAO.QueryDef Dim intI As Integer, strObjName As String

    Set db = CurrentDb
    ' Open an output file
    Open CurrentProject.Path & "\AccessSQL.txt" For Outp