SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 could not UPDATE table "[Microsoft.Jet.OLEDB 4.0
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Vishal_sql
Posting Yak Master

101 Posts

Posted - 02/08/2013 :  06:54:38  Show Profile  Reply with Quote
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

'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 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.
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000