Results 1 to 8 of 8

Thread: please help!!!!

  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Unanswered: please help!!!!

    Hello<

    How do I read data from the text file (login_name ,password,mail) and insert it into the table_user.password, table_user.mail fields for each table_user.login_name. Please give me some hints. Thanks a lot!

  2. #2
    Join Date
    Oct 2003
    Location
    Dallas
    Posts
    76

    ...

    this really depends on how you want go about doing this. You could simply just create a DTS package and import the text file into the table.

  3. #3
    Join Date
    Oct 2003
    Posts
    4

    Re: ...

    Originally posted by mkkmg
    this really depends on how you want go about doing this. You could simply just create a DTS package and import the text file into the table.
    I guess I need to write a script.

  4. #4
    Join Date
    Oct 2003
    Location
    Dallas
    Posts
    76

    ...

    what are you wanting to use to do this?

  5. #5
    Join Date
    Oct 2003
    Posts
    4

    Re: ...

    Originally posted by mkkmg
    what are you wanting to use to do this?
    I quess PLSQL. I have bits of code but can't put it together. Sorry.

  6. #6
    Join Date
    Oct 2003
    Location
    Dallas
    Posts
    76

    ...

    Sorry, I am in the Microsoft world and have DTS packages to do it, wish I could be more help.

  7. #7
    Join Date
    Oct 2003
    Posts
    4

    Unhappy Re: ...

    Originally posted by mkkmg
    Sorry, I am in the Microsoft world and have DTS packages to do it, wish I could be more help.
    Well thanks anyway

  8. #8
    Join Date
    Oct 2003
    Location
    Dallas
    Posts
    76

    .....

    if you are using oracle, I found this article on how to load text files into tables. hope this helps.

    http://www.orafaq.org/faqloadr.htm#HOW

Posting Permissions

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