Results 1 to 2 of 2

Thread: Reading text file and pushinto sql server

  1. Jul 12th, 2005, 12:15 PM #1
    TonySandhu
    TonySandhu is offline

    Thread Starter
    New Member
    Join Date
    Jul 2005
    Posts
    1

    Reading text file and pushinto sql server

    The problem i am facing is i have to read a text file which is like
    BAS
    00064491/000002-TXL-00002
    00064492/000003-AJS-00003
    AJSS
    00064495/000006-TUL-00006
    00064496/000007-YAK-00007
    JJC
    00064498/000009-KTR-00009
    00064499/000010-JOA-00010
    i want that it adds it in database fields as whenever it encounters line with five or less characters its adds in field1 and then the corresponding rows in filed 2 with field1 with same values till the new value arrives
    like
    Field1 Filed2
    BAS 00064491/000002-TXL-00002
    BAS 00064492/000003-AJS-00003
    AJSS 00064495/000006-TUL-00006
    AJSS 00064496/000007-YAK-00007

    and so on .... please help me in this as i have code written but not working as needed...Urgently need help.....
    Reply With Quote Reply With Quote
  2. Jul 12th, 2005, 12:27 PM #2
    vincentg
    vincentg is offline
    Hyperactive Member vincentg's Avatar
    Join Date
    Jun 2005
    Location
    Chicago IL, USA
    Posts
    261

    Re: Reading text file and pushinto sql server

    hi. I dont know if this could help you. Try to explore DTS in your MS SQL Server.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width