Have tried to record a macro in Excel 2002 that uses the
SQL INSERT INTO..SELECT statements.

The problem: Although I can get the database result that
I want in the spreadsheet by manually entering the actions
during the macro recording process, when I stop recording,
the resulting macro is empty.

Have confirmed that I can sucessfully record a macro to
execute SQL if I omit the INSERT INTO statement, and leave
only the SELECT statement.

So, there must be something about the INSERT INTO that is
preventing the macro recording.

Any workarounds?

Thanks,
David