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
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.
On Sat, Mar 5, 2011 at 11:13 AM, bbser 2009 <email@example.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?