• hi

    approach the problem from the other direction

    get the data from Excel, use [menubar] Data/Get External data... attach to the SQL Server DSN and access your data (or sp) using MS query. You can even automate the process to pass parameters (assigned in your spreadsheet) to the sp using VBA.

    i've been doing this for years in vary complexity

    regards

    ja@whiffin.net