configuring Excel to read query from sql
Hello,
I have to extract some data from SQL Server and save it in Excel files. The
data is gathered with SQL queries, using some SQL User Defined Finctions and
several Joins. And I have to send these files to somebody every day.
The question is how do I set this and is there posibility once it is set to
be saved (the configuration i mean) and reused every day so I dont have to
reconfigure it all the time?
Thanks
|