wrote ...

My goal is only to get the desired result
in Excel 2002, not to learn to write SQL or VBA.

The problem isn't that the INSERT INTO..SELECT syntax does
not return a result, because I do see the desired result
in the spreadsheet, but still the recorded macro is blank.

Forgive me but I'm failing to see what the problem is. You can use the
macro recorder and the MS Query wizard to write a SELECT query in a
macro. It sounds like you know how to edit the query to convert it to
an INSERT INTO..SELECT query. What are you looking for here?

Jamie.

--