Post reply

Import Excel to SQL Server

  • November 26, 2015 at 3:01 pm

    #399390

    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

  • December 1, 2015 at 8:15 am

    #1843215

    What springs to mind are two things.

    http://www.konesans.com/products/file-watcher-task

    and

    https://msdn.microsoft.com/en-us/library/ms141209.aspx

  • 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]

  • December 1, 2015 at 11:49 pm

    #1843406

    Sorry not clear with the ask here . Please clarify if you want to just pull the delta each week or the whole sheet ? I am sorry we need to provide the issue which you are facing so that we can try and help .

    All the best .

  • December 2, 2015 at 12:48 am

    #1843412

    Since EXCEL sheet update event should trigger data export into SQL server it's quite natural to automate the task at the EXCEL side with VBA script.

    Provide more details if more help is needed.

Viewing 5 posts - 1 through 4 (of 4 total)

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