Execute Batch of MySQL Statements through ODBC Connector when calling from excel

Question

I'm trying to execute multiple statements on a MySQL server and get the results into an Excel pivot table. As an example:

create temporary table if not exists a
select 1 as testcol;

select * from a;

Even if I have the MULTI_STATEMENTS flag set to 1 it returns a "problem obtaining data" error. Is there a way to do this?

It's a read-only server so I can't create a stored procedure.

Any help would be appreciated.

Thanks,

Alan