Post reply

Exporting data into multiple Excel files

  • June 15, 2012 at 9:01 am

    #260013

    I have some data in a table that I would like to output to separate files, one for each department. The department number and name are in the data so it would be nice to use that in the naming of outputed files. It seems that I should be using the Fetch, Next combination to do this but that is as far as I have been able to get. Can anybody point me in the right direction? I tried searching the forum but have not been sucessful.

    TIA,

    Jon

  • June 15, 2012 at 9:52 am

    #1501770

    This might help: http://www.sqlservercentral.com/articles/61542/

  • June 17, 2012 at 10:51 pm

    #1502081

    Yes, this looks very promising. I will try it. Also I found your link to forum ettiquitte to be quite helpful too. Thanks.

    Jon

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

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