Posting Yak Master
Posted - 02/08/2013 : 06:54:38
| Hi All,
I have created stored procedure for importing excel into SQL Server Database.
excel has column ready which is set Y to know which rows to import,
after running the procedure if the data is imported properly the excel is updated back with setting Y to successfully imported
for that I have dynamic query as below
SET R.[Ready to import]='successfully imported'
FROM OPENDATASOURCE (''Microsoft.Jet.OLEDB.4.0'','''+@setstring+''')...ResourceDemand$ AS R ... '
which after excuting fails some time and gives error
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" could not UPDATE table "[Microsoft.Jet.OLEDB.4.0]".
I have full access to the excel file.
Still I am not getting why I am facing this issue..
Any help would be highly appreciated.