Post reply

Ideas for Writeable Excel with SQL Query

  • January 9, 2015 at 5:05 am

    #314342

    Hi all,

    I have an assignment that I'm not sure how to approach and what the appropriate solution would be. Our users want a report to be available in an Excel file. This report will contain a table with several fields found in various SQL tables all from the same database and all connected through foreign keys. There will also be an additional Comment field that the user will be able to edit and upon request, the changes should be written into the Comment field of one of our tables. All other fields should be Read-Only.

    Info: I'm working with Excel 2010 and SQL Server 2008 R2.

    Any ideas what would be the best way to do this?

    Thanks in advance.

  • January 9, 2015 at 8:10 am

    #1769096

    To my knowledge you can't update data in excel and easily push it back to SQL. Getting the data into excel is easy, as you can have a data set. I think it's possible, but you may have to code it yourself. And I'm not sure if it'll work on your version of excel.

    Sorry I couldn't be more official help. Perhaps using a webpage would meet your needs better.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • January 12, 2015 at 12:12 am

    #1769404

    Thanks for the reply. I've asked around and this may be possible with Macros.... Not sure though and may have to do more research.

  • January 12, 2015 at 12:51 am

    #1769410

    Sorry I should also say that I have no idea how to do this....

    Any links or tutorials?

  • January 12, 2015 at 5:21 am

    #1769456

    I've got an intro to ASP.NET on my site. It's from a few yrs ago but I believe everything still holds.

    As far as how to do it all in excel I don't know. Try google for that one. In my opinion though, I don't think it's worth it.

    Excel is great but it's just not that kind of tool. Use something that's made for this kind of thing... like .NET.

    You may be able to strongarm excel into doing something like this but you could also put in a lot of work and turn your car into a boat.

    Anyway, there's the link:

    http://midnightdba.itbookworm.com/Video/Watch?VideoId=89

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

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

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