I always had an issue connecting to an AS/400 too.  The Rumba drivers dont interact with SQL Server for some reason very well.  I think when I finally got it...

What I have done in the past, is to implement a SP I found off the internet.

Its called sp_Write2Excel.  If you google it, you should find it.

In short, it executes...