[AccessD] Export query to SQL Server

John

Only thos e the upsizing wiz will pick up the reszt I do manually usually
creating stored procedures. Simly cut and paste the SQL into the Query
Analyser and convert to a stored procedure.

The QA will highligh the error lines for you. Slightly different version of
SQL used.

Access 2003 does a good job reporting non upsized queries which helps speed
this up a bit. I have head of a tool called Proc Blaster. Not sure of the
URL



Martin


----- Original Message ----- 
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: "AccessD" <AccessD at databaseadvisors.com>
Sent: Saturday, January 31, 2004 7:00 PM
Subject: [AccessD] Export query to SQL Server


> Is there a way to export an entire query to SQL Server?  I don't want to
> have to go manually recreate my queries out there.
>
> John W. Colby
> www.ColbyConsulting.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>