September 18, 2003 at 5:16 am
Looking for a way to import JPG files into a sql table. Saw some examples of creating JPG's from BLOB's but i want to go the other way.
Thanks,
gmp
September 18, 2003 at 5:22 am
Hi gmp,
quote:
Looking for a way to import JPG files into a sql table. Saw some examples of creating JPG's from BLOB's but i want to go the other way.
that one should help you
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12228
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
September 19, 2003 at 5:26 am
Liked this solution - have also gotten Bulk Insert to work. What I was really looking for was a stored procedure that i could just pass a Key and a JPG file name to.
greg
September 19, 2003 at 5:29 am
quote:
Liked this solution - have also gotten Bulk Insert to work. What I was really looking for was a stored procedure that i could just pass a Key and a JPG file name to.
textcopy or BCP could also do the job, I think. Haven't played with them yet.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply