Hi Friends,
I have an excel file, which is having 9 columns and one of the column is having an image. please help me how can i insert the excel with, which contains images and at the same time i need to retrieve the records including with images and display on UI.
I'm using SQL Server 2008, VS 2008
much appriciate your help.
Thank You,
Shaik
Iftikar HussainPosted Aug 23, 2013, 2:00 AM
http://stackoverflow.com/questions/2632715/retrieve-pictures-from-excel-file-using-oledb
http://joymonscode.blogspot.in/2009/01/reading-image-from-excel-file.html
Regards,
Iftikar
Murthuja ShaikPosted Aug 23, 2013, 1:34 AM
Thanks for your response. for ASP.NET.., here my problem is that, the excel file is having images and when i tried inserting it into DB, all other records are getting inserted, but images are not getting inserted..
so I need help on how can we read images from excel file and insert in to DB ?
Regards,
Shaik
Iftikar HussainPosted Aug 22, 2013, 11:22 AM
Are you looking for solution in ASP.NET or Windows Form?
you can refer the below link for asp.net
http://www.codeproject.com/Tips/300639/Import-Data-from-excel-to-SQL-server-using-Csharp
Regards,
Iftikar