Image capture from excel & save in database

Question

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 28-Sep-14 23:29pm

Mukesh Ghosh

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 29-Sep-14 5:47am

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Mukesh Ghosh · Accepted Answer · 2014-09-30T01:11:00

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.