We help IT Professionals succeed at work.

Why does this OPENROWSET(BULK... statement give an error?

Hello, I'm trying to import images from the file system into a column of data type 'image'.  An expert pointed me to the OPENROWSET(BULK... statement, but the code below gives an error:  Incorrect syntax near the keyword 'BUKL'.  Any ideas why?  The server is Microsoft SQL Server Workgroup Edition.  Any help is appreciated.
UPDATE db1.dbo.ImageValues SET Value =
  (SELECT * FROM OPENROWSET( BULK 'c:\...\Image 32.JPG', SINGLE_BLOB))

Open in new window

Comment
Watch Question

Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
what version of SQL Server are you using?
David ToddSenior Database Administrator
CERTIFIED EXPERT

Commented:
Hi,

Add a comma after the word bulk ...

BULK 'c:\...\Image 32.JPG', SINGLE_BLOB

Cheers
  David

Author

Commented:
2005 Workgroup Edition, v. 8.00.2187 on NT 5.2.  Comma doesn't seem to help.  Do I need to use the UNC rather than the local file name?
Oops, I lied, this is 2000 not 2005, which means that OPENROWSET(BULK... won't work.  Sorry, I'm at a new job and made an assumption (I know, I know).  Can anyone either (a) suggest an alternative method or (b) kill me?  I've upped the points.