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

Yes, there are a few ways to do this.

The "wizard driven" way to do this is to use Excel's
database query. Select Data>>Import External Data>>New
Database Query (this selection may vary based on your
version of Excel). Work your way through the wizard to get
your data.

The other way to do this is via VBA. This is much more
powerful, but much more complicated. An example of its
power is that you can create new Excel Functions to pull
in a value based on values in another cell and it will
recalculate with all other cells.

HTH

Paul