-
April 25th, 2011, 04:11 AM
#1
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.
-
April 25th, 2011, 10:57 AM
#2
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.
-
April 26th, 2011, 01:53 AM
#3
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?
-
April 26th, 2011, 07:46 AM
#4
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.
-
April 26th, 2011, 09:55 AM
#5
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.
-
April 27th, 2011, 12:28 AM
#6
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.
Tags for this Thread
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
|
Click Here to Expand Forum to Full Width
|