INSERT INTO..SELECT

[David Weilmuenster]

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

 

[Jamie Collins]

...

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.

--

 

[Guest]

Jamie, thanks. 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.

BTW, the data source is an Excel spreadsheet defined as an
ODBC source.

David

 

[Jamie Collins]

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.

--