Posted - 07/25/2013 : 00:17:33
| Good Morning,
I am trying to save the output of a stored procedure in excel file, i am using following code
'Data Source=d:\book1.xls;Extended Properties=Excel 8.0;')...[Sheet1$]
exec rptworkorderstatus2 ''
but i am getting this error :
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" does not contain the table "Sheet1$". The table either does not exist or the current user does not have permissions on that table.
Plz Correct me,thanks
Edited by - NehaSharma on 07/25/2013 00:25:48