"Copy and Paste" image into SQL Database.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aeconsta
    New Member
    • Oct 2008
    • 1

    #1

    "Copy and Paste" image into SQL Database.

    I want to add images to my database by copying and pasting the image.

    I am using MS SQL Server Express 2008 and MS VB Express 2008. I want to create a simple program that displays data including images (.jpg) of items and text that describes characteristcs about the items.

    The images are currently in a MS Word table. I would like to simply convert the table into an SQL database, but seems not possible. Failing that, I would like to copy and paste the images into the SQL table.

    I have tried different data types (image, binary, varbinary) all to no avail. I have searched the help sites but haven't yet hit upon a solution.

    I would appreciate any help.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    It would be better if you just store the file and path name on the database and just point to it on your APP side.

    -- CK

    Comment

    Working...