SQL DB to excel realtime

Hi,
 
You can do so by developing Windows Service or Some costume application.
 
but if you want a good solution then :
 
just write those query's which result you need sequentially
 
then save it in a SQL file
 
sqlcmd -S CAFRFD1LITPMA02 -i SQL FileName -o OutPutFileName [CSV | TXT ] -s
 
run this code in a Schedule, if you need individual files One by one then just change output file name Uniquely.
 
For that just add Date Time with file name using Commend Prompt
 
you can save this hole as Batch file and run it under Scheduler.
 
Commend Prompt Details Click Here[^]
Or Here[^]
 
For More Help Reffer : http://social.msdn.microsoft.com/Forums/en/transactsql/thread/b3f406e1-1b2e-4ee4-8d28-4470c0ea19f9[^]

What you can do is , create a stored proc and inside that write logic to export data to excel using openrowset. you can find some solutions about this in this link.
 
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926[^]
 
You can schedule a job for this sql proc and run periodically at the time interval you want.
 
hope this would give you an idea to take forward.

Sirs, I don't know anything about programming( Please if it is posssible can you say me conctrete steps...
I also found this one Database to Excel Spreadsheet[^] but I cannot use it I dont know how. The folder where my DB stored is C:\Dokumente und Einstellungen\gast731\Eigene Dateien\Eigene Datenquellen\WS0451_SQLEXPRESS master STUEP_ZYLINDER_TREND.odc how can I do it?