View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RioDD RioDD is offline
external usenet poster
 
Posts: 1
Default 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