"David Weilmuenster" wrote ...

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.

If you are referring to a Jet or SQL Server data source, I assume the
problem would be that the INSERT INTO..SELECT syntax does not return a
result set and the macro recorder stops recording when the MS Query
wizard is cancelled.

Any workarounds?

The workarounds depend on what you are trying to achieve. If your goal
is to learn how to write sql or VBA, I must tell you that both the
macro the recorder and the MS Query wizard write lousy code <g.

Jamie.

--