How to insert and retrieve an excel file in sql server 2008

Question

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 Hussain · Answer

I think in that case you need use office interop object. Please refer the below link 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 Shaik · Answer

Hi Iftikar 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 Hussain · Answer

Hi 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