How to read/capture Excel sheet data into the Oracle database table directly using .net application.

Question

0.00/5 (No votes)

See more:

Dear

All,

I have an excel sheet, in that i have lot data to importing into the oracle database directly thorugh a .net application. Here I have plenty of data in excel sheet, so we have to read this data and inserting into the oracle database directly using .net application. I want a .net application, here we browse that data content excel sheet with browse button, so we have to capture these excel sheet data and inserted into the oracle table directly.

Here data is columns as rows & rows as columns. So how to read in this case.

firstname      vijay        vikram       vikek      varun

lastame        kumar      rathod      goshal    kandari

mobile         45425      456546      54656     454615

like above my data in excel sheet so how capture this kind of data. please let me know.

please anybody have the solution about my requirement? please let me inform.

In Advance Thanks...

Posted 20-Jul-12 23:46pm

Maria Vinod

Updated 21-Jul-12 0:08am

Mehdi Gholam

v2

Add a Solution

Comments

Chirag Dhangar 23-Mar-14 2:23am

how can i download this file.....

2 solutions

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)

Kenneth Haugland · Answer 1 · 2012-07-21T12:10:00

Solution 1

I would create a DataTable and copy the selected cells to this, then send the data to the Oracle. Other than that, I dont think anybody is likely to give you a complete code that is ready to use.

Posted 21-Jul-12 12:10pm

Kenneth Haugland

Comments

Maria Vinod 25-Jul-12 2:35am

Thank you very much Kenneth Haugland. I dont ask total code for ready use, but i asked some logic to read columns as rows and rows as columns. i.e, my problem. Am currently using datatable to read that excel data, when coming to insert how to take columns & their data into the database directly... Thank you very much for your valuable response...

Chirag Dhangar 23-Mar-14 2:23am

how can i dwld this file

Kenneth Haugland 23-Mar-14 3:40am

???

woutercx · Answer 2 · 2012-07-21T12:20:00

Solution 2

Maybe call the Oracle loader tool from .NET?
http://docs.oracle.com/cd/E11882_01/server.112/e16536/ldr_concepts.htm#SUTIL003[^]
You're not specifying which version of oracle by the way.

Or this:
http://www.orafaq.com/node/848[^]