Results 1 to 3 of 3

Thread: oracle to and from execl sheet

  1. #1
    Junior Member
    Join Date
    Jul 2007
    Answers
    21

    oracle to and from execl sheet

    how data can be stored in oracle from excel sheet and vice-versa ? .

    any one make me clear.


  2. #2
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: oracle to and from execl sheet

    >>how data can be stored in oracle from excel sheet and vice-versa ?

    From Excel to Oracle

    Open the file in excel. Save it as CSV file. You can load csv file into oracle using SQL LOADER.

    From Oracle to Excel
    Spool the output to text file then open it in excel.


  3. #3
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: oracle to and from execl sheet

    there are a number of third party tools available for the purpose.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact