Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
|
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 15th, 2005, 07:03 AM
Registered User
 
Join Date: Mar 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Converting Access Queries Into Stored Procedures

Hi

I have been presented with 700 access queries which need converting into sql stored procedures, so I can produce reports from them using Crystal Reports. Is there an easy way or utility that can help, I have no money to spend on the conversion?

Thanks for your help

Mark

 
Old March 15th, 2005, 11:49 AM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 303
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Not sure if there is a tool out there that can help you but read this article (at the bottom of the page) it has some information on how to transform access queries into SQL stored procedures.

http://www.microsoft.com/resources/d...rt2/c0561.mspx






Similar Threads
Thread Thread Starter Forum Replies Last Post
Stored Procedures returning no results to access 50bmg_de SQL Server 2000 5 February 21st, 2006 04:58 AM
RecordSets vs Stored Procedures in Access Roy0 SQL Language 0 December 28th, 2005 02:02 PM
stored procedures and MS Access madhukp Classic ASP Basics 5 August 26th, 2004 12:22 AM
Pass-through queries vs stored procedures kendawg Access 2 October 8th, 2003 02:00 AM
Converting Access Queries to SQL cej2583 SQL Server 2000 6 June 30th, 2003 06:47 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.