Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Software to allow users to make changes in MSSQL database

Posted on 2010-11-16
1
Medium Priority
?
293 Views
Last Modified: 2012-05-10
We have a bunch of users who like to share and collaborate using Excel spreadsheets and inventory. In a couple of months, their will be a new ERP system installed, but until then I would like to put that information in a MSSQL database.

Other then:
a) internal created web pages
b) linked sheets from Excel to Database

what is a good software that will allow them to view/add/edit data in an Excel like format? Is there a good/free web based software that allows simple add/changes?
0
Comment
Question by:freshgrill
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 34152645
>> We have a bunch of users who like to share and collaborate using Excel spreadsheets and inventory.

I would suggest the below approach:

1. Import data from all Excel spreadsheets into SQL Server
2. Use either Access or Excel sheets to work on those data or create a simple application for the users to modify data.
3. When your ERP is configured, import records from SQL Server or use an ERP with SQL Server as backend.

>> what is a good software that will allow them to view/add/edit data in an Excel like format? Is there a good/free web based software that allows simple add/changes?

Best one would be to write a simple VB or C#.net Windows application to suit your custom needs.
0

Featured Post

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question