Run SQL-Server Query in Excel

Hi guys,
is there a way to run a SQL-query on a SQL-Server
within Excel?
(Is it possible to create any JOIN-querys and DATEDIFF-functions within
Excel-Microsoft Query?)
Thanks much guys,
MikeYes, is possible.
1. Start to record Macro.
2. Data > Import External Data > New Database Query .. > ...... > and so
on ..(Build a simple query and rerturn data to Excel)
3. Stop record Macro and Edit . You can change your query and run Macro
whenever you want.
"Maik Richter" <maik.richter2@.gmx.de> wrote in message
news:%23XeAJjvcEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Hi guys,
> is there a way to run a SQL-query on a SQL-Server
> within Excel?
> (Is it possible to create any JOIN-querys and DATEDIFF-functions within
> Excel-Microsoft Query?)
> Thanks much guys,
> Mike
>