CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
+ Reply to Thread
Results 1 to 6 of 6

Hybrid View

  1. April 25th, 2011 04:11 AM #1
    lovepanda
    lovepanda is offline Junior Member lovepanda is an unknown quantity at this point (<10)
    Join Date
    Apr 2011
    Posts
    2

    Wink How to Save CSV & Text File to Image Field in SQL table?

    Hi all,

    urgently need help on how to store CSV & Text file to an Image Field in SQl table.
    the table is using by some other application that's why i could not change the field data type.
    appreciate any suggestions.
    Thanks a lot.
    Reply With Quote Reply With Quote
  2. April 25th, 2011 10:57 AM #2
    dglienna's Avatar
    dglienna
    dglienna is offline ex MVP - Visual Basic Power Poster dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+)
    Join Date
    Jan 2006
    Location
    Chicago, IL
    Posts
    14,589

    Re: How to Save CSV & Text File to Image Field in SQL table?

    You can save a string (or an image) into one field, but the other program has to know about that field.
    David

    CodeGuru Article: Bound Controls are Evil-VB6
     2012 Samples: MS CODE Samples
    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!
    Reply With Quote Reply With Quote
  3. April 26th, 2011 01:53 AM #3
    lovepanda
    lovepanda is offline Junior Member lovepanda is an unknown quantity at this point (<10)
    Join Date
    Apr 2011
    Posts
    2

    Red face Re: How to Save CSV & Text File to Image Field in SQL table?

    Hi,
    currently already have a program to grab data from this 'image' field and populate it as an email attachment.
    so what i need to do is to fill in the 'image' field with my Csv/Text file data so that the program able to create attachment with it.
    any ideas?
    Reply With Quote Reply With Quote
  4. April 26th, 2011 07:46 AM #4
    dglienna's Avatar
    dglienna
    dglienna is offline ex MVP - Visual Basic Power Poster dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+) dglienna has a reputation beyond repute (3000+)
    Join Date
    Jan 2006
    Location
    Chicago, IL
    Posts
    14,589

    Re: How to Save CSV & Text File to Image Field in SQL table?

    You can SERIALIZE the image data, and store in one field, and the text in the other field.
    David

    CodeGuru Article: Bound Controls are Evil-VB6
     2012 Samples: MS CODE Samples
    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!
    Reply With Quote Reply With Quote
  5. April 26th, 2011 09:55 AM #5
    HanneSThEGreaT's Avatar
    HanneSThEGreaT
    HanneSThEGreaT is offline CG Bouncer Power Poster HanneSThEGreaT has a reputation beyond repute (3000+) HanneSThEGreaT has a reputation beyond repute (3000+) HanneSThEGreaT has a reputation beyond repute (3000+) HanneSThEGreaT has a reputation beyond repute (3000+) HanneSThEGreaT has a reputation beyond repute (3000+) HanneSThEGreaT has a reputation beyond repute (3000+) HanneSThEGreaT has a reputation beyond repute (3000+) HanneSThEGreaT has a reputation beyond repute (3000+) HanneSThEGreaT has a reputation beyond repute (3000+) HanneSThEGreaT has a reputation beyond repute (3000+) HanneSThEGreaT has a reputation beyond repute (3000+)
    Join Date
    Jul 2001
    Location
    Sunny South Africa
    Posts
    10,803

    Re: How to Save CSV & Text File to Image Field in SQL table?

    The only way to store images ( or any file for that matter ) into a database would be to use a Binary Reader / Writer. What concerns me is what database is the OP using?

    If it is Access 2007 or 2010, then there is an Attachment feature that can be used to save any sort of file into.
    All my Articles
    Hannes
    Reply With Quote Reply With Quote
  6. April 27th, 2011 12:28 AM #6
    DataMiser
    DataMiser is offline Elite Member Power Poster DataMiser has much to be proud of (1500+) DataMiser has much to be proud of (1500+) DataMiser has much to be proud of (1500+) DataMiser has much to be proud of (1500+) DataMiser has much to be proud of (1500+) DataMiser has much to be proud of (1500+) DataMiser has much to be proud of (1500+) DataMiser has much to be proud of (1500+) DataMiser has much to be proud of (1500+) DataMiser has much to be proud of (1500+) DataMiser has much to be proud of (1500+)
    Join Date
    Jul 2008
    Location
    WV
    Posts
    4,486

    Re: How to Save CSV & Text File to Image Field in SQL table?

    Agreed on the binary reader/writer, this is what I use to store images in SQL Server. No reason it shouldn't work for any file type.

    Haven't used Access 2007+
    Always use [code][/code] tags when posting code.
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


HTML5 Development Center

Click Here to Expand Forum to Full Width