Click here to Skip to main content
14,732,816 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a excel file which contain a column, now above column contain some image like jpeg,how to retrive that image & save in Oracle database?

Any help omnt this?
Posted
Comments
   
Did you try anything?
Mukesh Ghosh 29-Sep-14 6:16am
   
Till now i can have only excel read , it can read normal databut not image
Dim pram As OleDbParameter
Dim dr As DataRow
Dim olecon As OleDbConnection
Dim olecomm As OleDbCommand
Dim olecomm1 As OleDbCommand
Dim oleadpt As OleDbDataAdapter
Dim dt As New DataTable

olecon = New OleDbConnection

Dim cn As System.Data.OleDb.OleDbConnection
Dim cmd As System.Data.OleDb.OleDbDataAdapter
cn = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;" & "data source=C:\Users\acer\Desktop\ImageExcel.xls;Extended Properties=Excel 8.0;")
cmd = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", cn)
cn.Open()

cmd.Fill(dt)

cn.Close()
Mukesh Ghosh 29-Sep-14 8:37am
   
Any help on this, image contain null when fill dataset for image column
AndrewCharlz 30-Sep-14 6:36am
   
in the below it shows how to insert a excell into database may be this will be useful ..

http://streetrat.in/street-rat-discussions/Append-data-from-Excel-to-SQL-Server-existing-table-7.aspx?customauth=7

1 solution

Hello,
I got my solution. But i would like to share the same with all, as any cell can contain
Data,formula & also excel cell can't contain any image ,they can be place in sheet only.
We embed any image through link or as an object as embeded.

So ,logically it's not possible, after doing RND on this i come to this conclusion.
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900