Date:         Sat, 5 Mar 2011 14:56:05 -0600
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: OT: manually code SQL for Excel
Comments: To: bbser 2009 <bbser2009@gmail.com>
In-Reply-To:  <000001cbdb58$a4da8360$ee8f8a20$@com>
Content-Type: text/plain; charset=ISO-8859-1

You can also do it through VBA, there are a lot of resources out on the web
for that - just google it.

-Joe

On Sat, Mar 5, 2011 at 11:13 AM, bbser 2009 <bbser2009@gmail.com> wrote:

> Hi all,
>
> I am new to using standard SQL for Excel.
> I was told to follow the path "Data --> From Other Sources --> From
> Microsoft Query --> ..." in Excel 2007 to use SQL.
> I found this way was very annoying and I had to keep dealing with many
> wizard windows.
>
> I would like to write down the whole SQL code and hit a button to make it
> run, just like what we usually do in a SAS enhanced/program editor.
> Could you please tell me how to do this?
>
> Thanks.
> -Max
>