+ Reply to Thread
Results 1 to 3 of 3

Typing the SQL vs Using Query Interface

  1. #1
    Forum Contributor
    Join Date
    08-29-2011
    Location
    Minnesota
    MS-Off Ver
    Excel 2013
    Posts
    106

    Typing the SQL vs Using Query Interface

    First, I tried searching multiple times for a similar post, but I can't get the search to return any hits for "SQL", and I don't know why. I can see SQL in the first page, but my searches returned literally no results. I don't know what I did wrong, but I did TRY to search. My Google searches also just fill me full of results about how various other SQL databases can handle way more than Access or how to type SQL into Access; neither of which answer the question I'm trying to ask.

    I'm relatively new to Access and I don't understand when or why you would want to write SQL directly instead of using the built in Query interface that does the SQL for you. Is it like how with Excel you can do a lot more with VBA than you can with formulas and "base" excel, or is it just that Access lets you see the SQL code, but there's really no benefit to typing the SQL code directly?

    Thanks for your time!

    -Opie

  2. #2
    Registered User
    Join Date
    11-24-2012
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Typing the SQL vs Using Query Interface

    There are a number of restrictions in the Access query editor, certain joins and expressions simply can't be entered, so have to be written as SQL and stored as such.
    If you open some of these stored queries in the query designer it will break them.

    Also, Access loves a set of parentheses. If it can add twenty squillion pairs around a few Where clauses it will, causing it to sometimes be a lot less readable.

  3. #3
    Forum Contributor
    Join Date
    08-29-2011
    Location
    Minnesota
    MS-Off Ver
    Excel 2013
    Posts
    106

    Re: Typing the SQL vs Using Query Interface

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel VBA interface
    By MartinV10 in forum Excel General
    Replies: 2
    Last Post: 08-23-2019, 03:11 AM
  2. Dynamic interface
    By nymm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2011, 05:36 PM
  3. VBA interface
    By Jacques Grobler in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-13-2011, 04:39 AM
  4. VB interface
    By AD108 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2006, 04:35 AM
  5. interface with other applications
    By Mike Macgowan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2005, 05:06 PM
  6. Interface to MS Project
    By Kent in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1