Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2004
    Location
    Kolkata, India
    Posts
    1

    Unanswered: Transferng data from Excel

    Hi,
    I've started using Oracle recently. Please tell me whether I can transfer an excel file to Oracle ? I'm using MS-Excel-98 and Oracle 7.3....If it is not compatible, please advise the possible solution

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: Transferng data from Excel

    Originally posted by palsudip
    Hi,
    I've started using Oracle recently. Please tell me whether I can transfer an excel file to Oracle ? I'm using MS-Excel-98 and Oracle 7.3....If it is not compatible, please advise the possible solution
    Try to use search in this forum you will get the answer...

  3. #3
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    Hi,

    U mean to say that u want to transfer data from excel file to oracle database?
    In oracle u can used sql loader tool for the same purpose.
    And i think, sql server has some tool which can be used to import data from excel to oracle.

    Thanks,
    Pagnint
    (No need to search web before posting new question)

  4. #4
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    Hi ika,

    I think he palsudip has not read saravana post
    But i still think newbie can post here without sreaching in the forum itself.

    Cheers,
    Pagnint
    (No need to search web before posting new question)

  5. #5
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482
    Originally posted by paginit
    Hi,

    U mean to say that u want to transfer data from excel file to oracle database?
    In oracle u can used sql loader tool for the same purpose.
    And i think, sql server has some tool which can be used to import data from excel to oracle.

    Thanks,

    Save the Excel data to CSV or text format (using Save as) and as paginit said use the sql loader "sqlldr".
    Last edited by ika; 04-13-04 at 13:08.

  6. #6
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208
    You can also import the xls file into Access. Create a link table to the Oracle table, and then insert into the link table. This will push the data into the database. You should be able to find a post with some good info and examples on importing data to Oracle from Access.

    HIH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •