Exporting data from Excel to Oracle


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Exporting data from Excel to Oracle

  1. #1
    sunny Guest

    Exporting data from Excel to Oracle


    Hi Everyone,
    Can anybody help me getting an exe or code with which I can Export
    data from excel to oracle database.

    Sunny

  2. #2
    Steve Guest

    Re: Exporting data from Excel to Oracle


    Do you have MS Access? Bringing it into MS access converts it to a "real"
    table with a stucture. Set up a ODBC Driver then export the data in Access
    to Oracle using the ODBC driver and the access export function.

    Steve


    "sunny" <sun@hotmail.com> wrote:
    >
    >Hi Everyone,
    > Can anybody help me getting an exe or code with which I can Export
    >data from excel to oracle database.
    >
    >Sunny



  3. #3
    Angelo Cappelli Guest

    Re: Exporting data from Excel to Oracle


    "sunny" <sun@hotmail.com> wrote:
    >
    >Hi Everyone,
    > Can anybody help me getting an exe or code with which I can Export
    >data from excel to oracle database.
    >
    >Sunny



  4. #4
    Angelo Cappelli Guest

    Re: Exporting data from Excel to Oracle


    "sunny" <sun@hotmail.com> wrote:
    >
    >Hi Everyone,
    > Can anybody help me getting an exe or code with which I can Export
    >data from excel to oracle database.
    >
    >Sunny



    Save the file as a .csv file and use sqlldr to import the data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center