Results 1 to 2 of 2

Excel SQL: which functions can I use?

This is a discussion on Excel SQL: which functions can I use? within the Excel Questions forums, part of the Question Forums category; I do all my SQL statements using excel VBA . I search for help with syntax and statements online, but ...

  1. #1
    Board Regular
    Join Date
    Feb 2012
    Location
    Wisconsin, USA
    Posts
    127

    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
    127

    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,

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