excel data convert into oracle9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: excel data convert into oracle9i

  1. #1
    Join Date
    Sep 2004
    Location
    pakistan
    Posts
    4

    excel data convert into oracle9i

    Dear

    I want convert my excel data into oracle 9i i have four column in excel sheet (1 NAME,2 SALARY,3 DATE,4 EMPLOYEE NUMBER) and number of record is 250 what i do convert excel data into oracle9i

    Please help as soon as possible

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    save it as a csv file, then use external tables or sql*loader to load the data in

  3. #3
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    If you need to write a procedure to do this for you (i.e. you need to do this load on a rgular basis), search Ask Tom for UTL_FILE.

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