Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

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?
0
freshgrill
Asked:
freshgrill
1 Solution
 
Raja Jegan RSQL 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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now