• I recently wrote this blog post[/url] in which I reference the article you mentioned, and I show how to use code to handle multiple result sets. It's not specific to Excel, but you could probably adapt it to fit that purpose.

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices