You are working as C# developer, you need to write a program that should export all the tables to Excel files. Each Table should be export to separate Excel file and Excel file should have date-time added to it.
Below script can be use to export all the tables from SQL Server Database to Excel files.
string connstring = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source="
I executed above program and it was able to generate Excel files for all the SQL Server tables and load data to them.