Solved

Imort Excel data to oracle database using ASP.NEt & C#

Posted on 2014-10-08
5
1,628 Views
Last Modified: 2014-10-14
Hi Team,
I have one excel file.I want to import excel file to data base using asp.net and C#.

Database is oracle.

Can u plz send example code

Thanks In Advance
0
Comment
Question by:mannevenu26
5 Comments
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
Comment Utility
You could do it easily if you have access to any of the GUI tools like SQL Developer or Toad

There are various examples on net with screenshots(on how to do this via tools) see one below for toad

http://www.c-sharpcorner.com/UploadFile/1326ef/upload-exceltxt-file-data-into-oracle-table-using-toad/

However, if you want to do it via ASP.NEt then refer to this post where in you have to place your table name and connection strings and you are good to go and use it on your own

http://forums.asp.net/post/5372020.aspx
0
 

Author Comment

by:mannevenu26
Comment Utility
I think above is sql server database.Can you please post code for ORACLE database
0
 
LVL 12

Accepted Solution

by:
Ramkisan Jagtap earned 500 total points
Comment Utility
You can do it using Oracle data provider.
For reference check following link:
http://dotnetslackers.com/articles/ado_net/BulkOperationsUsingOracleDataProviderForNETODPNET.aspx

Download the Oracle Data Provider for .net:
http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

you can download the getting started sample[ODP.NET]:
http://www.oracle.com/technetwork/indexes/samplecode/dotnet-sample-522126.html
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
I cannot provide a specific example as I've never gone from Excel to Oracle.

I have written code using OpenXML SDK:
http://msdn.microsoft.com/en-us/library/office/bb448854(v=office.15).aspx

That takes data from Oracle and inserts the data into an Excel 'template' that I have.

The OpenXML SDK allows you to work with native Office files quite easily.

I agree with the link above:  ODP.Net is the best way to use Oracle in .Net.

I've been using the new 12c Managed Driver for a little while and have been quite happy with it.  The bonus to using it is it doesn't require any Oracle client install like the regular ODP drivers.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now