Post reply

Export multiple txt files

  • January 5, 2005 at 8:23 am

    #84501

    Hi there

    I have a tabel with some stuff and a colon with 320 different areacodes 

    Now I want to export the table into 320 different txt files, one for each areacode, containing all the data per area.

    I'm not so interested in doing 320 seperate exports.

    If anyone have way to do this a better way, a would appriciate it alot.

    Regards Joejoe

       

     

  • January 5, 2005 at 10:31 am

    #536029

    I would suggest to loop through table, dynamically build the bcp out string and execute it for each rows.

    I hope it helps.

    Thanks,

    Ganesh

     

  • January 6, 2005 at 1:02 am

    #536118

    Sounds like a good idea. The problem is that I don't have any experince in programming, but I am very interested in learning it.  

    Never heard about bcp utility before, but I have just read the bol subject, and this leads me to a new question.

    How do I combine the loop with the bcp out string, first loop and then bcp or loop within bcp?

    Thanks for helping me

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply