automatization of a database

[salimm]

Hello,

I'm a new intern, and my mission is to solve the problem of how supply & demand are managed in the company; indeed, they collect data via excel files, so data is instructed, not clean and "manual".


I plan to work with SQL server, for the creation of a database from the beginning, but when I think about the data filling phase, I have no idea in fact, in particular that the filling is done every month, and since the managers cannot always code with SQL-already it will come back to the same problem of manual filling in with excel and on the other hand, they cannot learn SQL-so I wanted to know if we can connect sql server to an interface that can easily be used by managers for data insertion.

I do not know if I was clear, but already if you have a proposal do not hesitate please, if there is another way than SQL server, or if you do have other solutions, I am at your disposal.

Since I've never programmed a graphic interface, this part of job bothers me, so if you do have other suggestions, I'd be very grateful.


Thank you for your help,

Best regards

 

[snoopez]

Mate, you are pretty much visiting the wrong forum for that questions. At least the cracking section is the wrong place to ask for that - you should have posted this in the coding section. I suggest to search for a common developer forum and ask there.

But: if you do not need SQL server for any reason, save a lot of money and set up a cheap local web server with MySQL or any other database engine like that. Then look for any PHP (or such) developer who can build you a simple website connected to the database you want to use. PHP is still an option and provides everything you need for an interface with which people can enter the gathered data und to store that information in a databse.