I have an Excel file in
C:\testing.xlsx. I am exporting data from my database table to Excel using
[OPENROWSET (Transact-SQL)]1 method. Now I want to
- clear or delete all rows in my Excel file by executing some query in SQL Server
- delete or create new Excel file in specified path (ie
C:\) from SQL Server
Can I do this? If, please suggest me how to do that?