Post reply

Updating SQL table from external source

  • August 24, 2017 at 3:56 am

    #328053

    Hi, 

    I am not sure if this post is meant to be in this thread so apologies in advance. 

    I have been asked to create a report that pulls data from a SQL table into excel. However, the end-user isn't SQL savvy and as a result for my own sanity, I am trying to work out a way to update the SQL table based on the actions of the end user. 

    So one of the columns in the excel table has a data validation drop down and each time the end user changes the status of each row and saves the file I want to update the status change in the corresponding SQL table.

    I have never done this before but I understand it is possible. 

    All suggestions are welcome 🙂 

    thanks in advance 

  • August 24, 2017 at 4:09 am

    #1956558

    Excel isn't a great tool for doing stuff like this, in all honesty. it's great for collecting data from SQL server, but I don't suggest using it the other way.

    If you don't want to use a "home grown" application, perhaps you might be better using Microsoft Access, with a SQL Server database back end? For end users, it can be made to be quite a similar experience to Excel, and will handle to In/Out processes as standard.

    Thom~

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

  • August 24, 2017 at 4:23 am

    #1956559

    Great ! 

    I will give it a try

    thanks

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

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