how to import data from a notepad text file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: how to import data from a notepad text file

  1. #1
    Join Date
    Jan 2002
    Posts
    83

    how to import data from a notepad text file

    hello all

    I have a set of text files, which I would like to import data into Oracle. The text file contains 5 columns and approx 100 rows.

    Is there a way to import this data into Oracle in a new table.
    Also if possible how to go about in Sql Server 7.0 ?


    thnakx
    regards
    ICEMAN

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    use SQL*LOADER in Oracle.

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    i would be tempted to just use a decent text file editor (like Ultraedit) to edit the lines by turning such lines as ...

    1,3,01-dec-2002,john,smith

    ... into ...

    insert into my_table values(1,3,to_date('01-dec-2002'),'john','smith');

    i find it takes me less tha n a minute to do so, and the n the file can be pasted into SQL*Plus. Much faster for this data volume than writing/debugging sql*loader
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Jan 2002
    Posts
    83

    i dont have sql loader

    hi

    i have downloaded oracle 8.1.6 from oracle. I dont have sql loader in my program list !!!!

    Have I made amistake somewhere in installation ????


    thnakx
    ICEMAN

  5. #5
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: i dont have sql loader

    Originally posted by iceman
    I dont have sql loader in my program list !!!!
    It is a command line utility. Type 'sqlldr' at the command prompt.

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: how to import data from a notepad text file

    Originally posted by iceman
    hello all

    I have a set of text files, which I would like to import data into Oracle. The text file contains 5 columns and approx 100 rows.

    Is there a way to import this data into Oracle in a new table.
    Also if possible how to go about in Sql Server 7.0 ?


    thnakx
    regards
    ICEMAN
    use the utility provided by oracle/sql server....
    Orcale : SQLLDR.exe
    SQL Server 7.0 : BCP.exe

    guess u r new....
    better go thhru docs......

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

Posting Permissions

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



Click Here to Expand Forum to Full Width