[AccessD] Upsize wizard => Queries

Sure. 

<AIR CODE>

Dim qd as QueryDef
Dim strSQL as String 

	For Each qd in QueryDefs
		strSQL = qd.SQL
		' Save the sql somewhere
	Next qd
	
</AIR CODE>

Lambert	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Sad Der
Sent: Wednesday, July 11, 2007 2:45 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Upsize wizard => Queries


Ok, was afraid of that. Is there a way to retrieve the
SQL text of the query in a automated way?

Regards,

Sander



--- "Robert L. Stewart" <robert at webedb.com> wrote:

> The syntax for the queries is too different to be
> migrated. You had to do that yourself.
> 
> Or, you can change your default to be SQL-92 (I
> think)
> compliant. Then you can simply copy and paste the
> SQL
> between them. But, either way, you still have to do
> it
> yourself.
> 
> Robert
> 
> At 07:26 AM 7/10/2007, you wrote:
> >Date: Tue, 10 Jul 2007 04:37:42 -0700 (PDT)
> >From: Sad Der <accessd666 at yahoo.com>
> >Subject: [AccessD] Upsize wizard => Queries
> >To: Acces User Group <accessd at databaseadvisors.com>
> >Message-ID:
> <460545.53873.qm at web31611.mail.mud.yahoo.com>
> >Content-Type: text/plain; charset=iso-8859-1
> >
> >Hi group,
> >
> >Using the upgrade wizard I can migrate the tables
> and
> >data in a couple of minutes to SQL Server.
> >
> >(Action) Queries are not migrated.
> >
> >Does anybody know of a tool that migrates queries
> to
> >sql server views and/or sp's?
> >
> >TIA!!!!
> >
> >Regards,
> >
> >Sander
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



 
____________________________________________________________________________
________
Be a PS3 game guru.
Get your game face on with the latest PS3 news and previews at Yahoo! Games.
http://videogames.yahoo.com/platform?platform=120121
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com