How to setup daily SQL server export to csv text file?
Yes, no problem.  Use BCP (which is a command line tool) to export the data.  Once you have the parameters the way you like, schedule this as a SQL Agent job.