Excel SQL: which functions can I use?

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Excel SQL: which functions can I use?

  1. #1
    Board Regular
    Join Date
    Feb 2012
    Location
    Wisconsin, USA
    Posts
    209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel SQL: which functions can I use?

     
    I do all my SQL statements using excel VBA. I search for help with syntax and statements online, but more often than not I try to use some sweet-sounding SQL function and it comes back with:

    sql0204: DATEADD in *LIBL type *N not found

    Where dateadd was the latest nifty function I'm trying to use. Is there some way I can use this function? Or is there somewhere I can find an exhaustive list of available Excel VBA sql functions?

    I'm also posting this question at:
    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=179379

  2. #2
    Board Regular
    Join Date
    Feb 2012
    Location
    Wisconsin, USA
    Posts
    209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel SQL: which functions can I use?

      
    Answers from the other forum:


    Excel doesn't actually "support" SQL, nor does VBA. They
    offer a programming interface that lets you connect to SQL databases, and you
    get access to whatever functions/features that SQL product
    supports.

    Regarding DATEADD and the error message you're getting, it
    looks like you're accessing an AS/400 - DB2 database, which doesn't support that
    function.

    SQLTeam is a Microsoft SQL Server website, so we really can't
    help with DB2, but dbForums can:
    http://www.dbforums.com/db2/1637371-help-there-dateadd-function-db2.html


    Now that points me in the right direction! The search term as400 helped me find a couple manuals:
    http://publib.boulder.ibm.com/html/a...2/rbafzmst.pdf
    http://publib.boulder.ibm.com/infoce...2/rbafzmst.pdf
    Not completely sure which one is exactly right for me, but these should provide a rich source of possible things to try and a place to look up potential functions that don't seem to be working,

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com