Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Vishal_sql
Posting Yak Master
102 Posts |
Posted - 2013-02-08 : 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 importedfor that I have dynamic query as below'UPDATE R 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 errorThe 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. |
|
|
|
|