How to import data from sql server table into an excel file by creating the rows dynamically in the excel according to the dataabase??

How to import data from sql server table into an excel file by creating the rows dynamically in the excel according to the dataabase??

There is a table in sql server having 6 columns but the rows keep on increasing in the table time to time. So how to create an excel file according to that and keep updating the same....???