Import Excel File into Oracle DB using C# - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Import Excel File into Oracle DB using C#

peterstonepeterstone Posts: 1Member
Hi All,

I am a complete newbie to C# and a small amount of programming experience.

I need to create an application that imports the data from an excel file into a table in an oracle database. Can somebody assist me with the following (or give some links) -

1. Connection string to the oracle DB
2. Importing the data from the excel file into the DB.

Many thanks for your assistance
Peter

PS - please remember I am a complete newbie to C#

Comments

  • PsightoplazmPsightoplazm Posts: 332Member ✭✭
    Best site ever for connection strings
    [link=http://www.connectionstrings.com/]here[/link]

    As for gathering info from the excel file - you can actually connect to an excel file using an ODBC connector as if it was a database. I haven't looked for it - but I'm sure that connection string will be on the above mentioned site as well.
    ><//~Psightoplasm`~
Sign In or Register to comment.