Hi,
You can retrieve the From SQL Server by Creating a connection in Excel with
SQLServer..
Data -> Get External Data -> From Other Source -> From SQL Server
Give the Server Name and all details , Excel will Create a connection
automatically with Server and take all the Data from Select
try this
http://www.ozgrid.com/forum/showthread.php?t=83016&page=1
On Sat, Jul 2, 2011 at 9:09 PM, Markkim wrote:
> Hi
>
> I know a bit of SQL.. can write a bit of complicated query..
>
> At work, I don't have Write right to SQL server.. because my role is to
> investigate and report.
>
> I
