On Jul 20, 6:46 pm, Candyman
wrote:
I write Excel to pull data from a DB2 database, but now I have to Insert data
into a temp table before I can run the SQL to get the real report data.

The first few in the series insert data into a DB2 database. (in SQL writing
code program like Rapid SQL returns a message like "13620 row(s) affected.".

Then the real reporting query runs to return data.

I can return data, but I have not figured out how to handle the success
message. I even created a temporay sheet for the 'Success' to post. The SQL
jams trying to bring back the results.

Did you try using the execute method instead of openrecordset? If you
posted a bit of the code it would be easier to see what you are using
and suggest corrections.

Peter Richardson