Software to allow users to make changes in MSSQL database

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?
freshgrillAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
>> 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.