sql server 2008 - Export SQL Data to Excel Insert into specified Sheet -

ultimately trying export data sql table , insert tab in excel sheet , have mailed group. not 100% set on method of doing way found online seems suggest me want unfortunately cannot find fix specific issue. every time try error implying file read only. have checked file , have rights have rebooted server thinking maybe locked in memory still nothing. have been googling day long , have reached breaking point on one. windows 2008 r2 enterprise server sql server 2008.

exec sp_msset_oledb_prop n'microsoft.ace.oledb.12.0', n'allowinprocess', 1  exec sp_msset_oledb_prop n'microsoft.ace.oledb.12.0', n'dynamicparameters', 1    insert openrowset('microsoft.ace.oledb.12.0',  'excel 12.0;database=d:\template\availability.xlsx;imex=1;hdr=yes','select [site id],[schedule date] [quota_points$a:j]')   select [site id],[schedule date]   (select [site_id] 'site id'       ,[schedule_date] 'schedule date'         [smb].[dbo].[jobavailability]) 

error message :

error(s) ole db provider "microsoft.ace.oledb.12.0" linked server "(null)" returned message "cannot update. database or object read-only.". msg 7399, level 16, state 1, line 1  ole db provider "microsoft.ace.oledb.12.0" linked server "(null)" reported error. provider indicates user did not have permission perform operation.   msg 7343, level 16, state 2, line 1 ole db provider "microsoft.ace.oledb.12.0" linked server "(null)" not insert table "[microsoft.ace.oledb.12.0]".