Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Import Excel to SQL Server RE: Import Excel to SQL Server

  • December 1, 2015 at 8:29 am

    #1843221

    demin99 (11/26/2015)

    Hi All,

    We have an excel file which changes every week.Weekly data will be added to each column in excel every week. I am trying to load the data to SQL server.How can I automate this process.

    for eg

    previous week : w1,w2

    now : w1,w2,w3

    next week : w1,w2,w3,w4

    Any help will be appreciated.

    thanks,

    Demin

    What is the format of the table(s) into which you are importing the data?


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]