January 20, 2010 at 1:50 am
One user needs to do bulk insertion into database from excel file. I granted him BULKADMIN role as well as he is also owner of db (db_owner). But while executing below statement, he is getting the error:-
Cmd.CommandText="BULK INSERT dbo.tempLDRsupv924 FROM '\\chr-ba- dev\filename.csv' WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '');"
Set objRS = cmd.execute
Error it produced:
Microsoft OLE DB Provider for SQL Server error '80040e14'
You do not have permission to use the bulk load statement
Is it mandatory to assign sysadmin role also for bulk insertion? One more thing that if I use like
Database_name.dbo.tempLDRsup924 in query will solve his problem?
How to resolve it?
January 20, 2010 at 6:05 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic849572-338-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2010 at 7:15 am
I just cross posted it in SQL Server 2008 forum beacause I thought people might not be navigating enough in SQL Server 2005 forum.Thats it.:cool:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply