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 ...
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:
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
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
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:
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,