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?