SQL syntax

Posted on 2009-02-11
Last Modified: 2012-05-06
Does anybody know of an online tool which can convert MS Access SQL syntax into SQL 2005 Server syntax
Question by:Mr_Shaw
    LVL 14

    Accepted Solution


    here is a snipit from

    The Access to SQL Server upsizing wizard is the best way to start.  There's a different version for each version of Access.  

    The Upsizer that comes with Access '97 does a pretty good job but won't convert parameterized queries.  This leaves you in the position of having to code them yourself.  I've written code to convert these but moving up to the Access 2000 upsizing wizard is another solution.

    The Upsizer that comes with Access 2000 converts parameterized queries into stored procedures.  For this reason it may be worth converting your Access '97 db to 2000 first and then using this Upsizer.

    I've also written an article on converting Access database to SQL Server.  It's from 1999, before Access 2000 was available but much of it is still relevant. It's available for free at

    One other thing:  I've found that it's a good idea to convert in multiple steps.  First, Upsize the database schema, then move the data.  The upsizer sometimes chokes on some of the data movement.  I generally use DTS to move the data, not the upsizer, but sometimes you can even use Access copy and paste to do the job.


    Author Closing Comment

    Emes... how true!

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
    Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now