Post reply

Super Simple SQL Front End

  • July 16, 2012 at 11:21 am

    #392755

    We need users to be able to enter data into a SQL Server 2008 R2 table. They should be able to update or insert data to that one table. That's it. These are business users, not technical users. What is the easiest way to get this done? I was thinking an MS Access 2010 ADP, but I'm sure there are easier methods that I don't know about.

  • July 16, 2012 at 11:29 am

    #1513224

    web page with a simple aspx grid, i would think.

    easy to implement, no software to install.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 16, 2012 at 11:48 am

    #1513234

    We did this by writing a stored procedure that imported an excel file. The idea was that out inside sales team would track their calls throughout the day into an excel spreadsheet, save it to a network folder, and then use a web interface or SSRS to import the data. It was easy to build and maintain, just make sure they close the file before trying to import 🙂

    Jared
    CE - Microsoft

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

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