Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
krausr79
Starting Member
19 Posts |
 Posted - 2012-10-01 : 09:34:55
|
| 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 foundWhere 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.mrexcel.com/forum/excel-questions/662196-excel-sql-functions-can-i-use.html#post3281975 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-01 : 09:39:43
|
| 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 |
 |
|
|
krausr79
Starting Member
19 Posts |
Posted - 2012-10-01 : 10:31:56
|
| Now that points me in the right direction! The search term as400 helped me find a couple manuals:http://publib.boulder.ibm.com/html/as400/v4r4/ic2924/info/db2/rbafzmst.pdfhttp://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmst.pdfNot 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, |
|
|
|
|
|
|
Excel SQL: Which functions can I use?