SQL query to export one database to a new Excel spreadsheet


  • Friends,

    I have a database named FR50 and I would like to create a script that will allow me to export daily all of the contents of a table called "basic" to Excel format.   The name of the output file should be basic.xls and always be saved to the D: directory.   Can this be easily done in a way where I can do this unattended at night?

    I would like to have the code and then I suppose I can set it up to run on its own at a certain time of night.  I will be using a batch file program to first delete the "old" Excel file so there are no overwrite issues.

    Thank you very much!

    Friday, November 08, 2013 9:00 PM


All replies