Check ODBC addin on the tools menu where obscure functions are. I'm not in front of computer where I used it, and it was long time ago, but it rings the bell
IF I remember more I'll post back. I do remember having to do some work in VBA so that the ODBC parameters go to the registry one so users don't have to reenter over and over.
Edited: The Addin is xlodbc.xla
SQL functions are described in Microsoft knowledgebase, google for KB120870 and KB214289
Edited by tos226, 24 May 2007 - 09:28 PM.