#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    mozambique
    Posts
    4
    Rep Power
    0

    Question organising and schedualing a file


    i eve a text.txt and i want to organize it (text.txt) so that all the names must be in the name column, all the numbers must be in the number column, all the last name must be in the last name column. All the columns must be separated by a tab or a coma ( , ) . after that, the file( text.txt) as to be imported to a table every day at a certain hour ( schedualing ) automaticaly.
    The sql must import the content of the file (text.txt) automaticaly every day.
    Last edited by mrl_sousa; November 28th, 2003 at 04:41 AM.
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    What do you mean by "organize a file"?
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    mozambique
    Posts
    4
    Rep Power
    0
    i eve a text.txt and i want to organize it (text.txt) so that all the names must be in the name column, all the numbers must be in the number column, all the last name must be in the last name column. All the columns must be separated by a tab or a coma ( , ) . after that, the file( text.txt) as to be imported to a table every day at a certain hour ( schedualing ) automaticaly.
    The sql must import the content of the file (text.txt) automaticaly every day.

IMN logo majestic logo threadwatch logo seochat tools logo