Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2014

    Unanswered: Sql loader ctl file

    Hi I have a problem with importing data into multiple tables. Anybody can help me with writing to the control file that import from CSV into multiple tables.

    lets say I want column 1,2,3 from EXCEL CSV into table employee and table 4,5,7 into table employee_info.

    Please help me

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    import the whole excel file into the db
    then using a select into query/queries move the data from that one tabe

    OR write a process that inserts data as required into what ever tables using say PHP or whatever scripting/front end tool you have available

    OR use a tool HeidiSQL

    OR see if there are Orcale equivalents of PHPmySQLAdmin or dbImport
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >Hi I have a problem with importing data into multiple tables.
    does the data file reside on the DB Server system?
    If so, then use EXTERNAL TABLE instead of SQL*Loader
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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