Export to Excel

  • Hi
     I want Data from the Sql table to Excel in predefined Excel Template . I have attached file and this should be auto schedule
    Thanks

  • What is your question here exactly? You seem be staying us to do your work for you. The users here are volunteers, we don't get paid to help you.

    Could you please expland on your post? It'll really help if your ask a question, include what you've done so far, where your stuck and any errors you've received.

    Thanks.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • jagjitsingh - Sunday, June 10, 2018 2:50 AM

    Hi
     I want Data from the Sql table to Excel in predefined Excel Template . I have attached file and this should be auto schedule
    Thanks

    Create a stored procedure to get the data you want, then use an SSIS task to export (use the Wizard maybe), then add the job to a schedule?

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

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