Re: INSERT INTO..SELECT

anonymous_at_discussions.microsoft.com
Date: 07/31/04 

Date: Sat, 31 Jul 2004 07:41:28 -0700

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 spread***, but still the recorded macro is blank.

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

David

>-----Original Message-----
>"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 spread*** 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.
>
>--
>.
>