SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Excel, SQL, and websites
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lordterrin
Starting Member

4 Posts

Posted - 08/26/2014 :  10:56:03  Show Profile  Reply with Quote
I have been working on a rather large project for a while that bases itself off of a series of reports that are generated internally by our company in .xls format. I'm at the point where taking in all of this data and exporting it back out into another .xlsx file is just too cumbersome, and does not allow me to do what I want with it.

I have an idea of how I'd like to move this project out of Excel and into something else, but I'm not sure where to start. What I'd like to do is the following:
.
1 - Take the various files that I get each day and run the same macros on them as I do now, but instead of populating the data back into a new sheet, populate an SQL database with the information.
2 - One of the biggest issues I'm having with Excel is the whole "only one person can use this at a time" thing. Even with shared wookbooks, it's just not a good solution when I need 50 people to be able to load data and make changes to it in real time. I want to create an internal website that will employ this SQL database and allow multiple people to make changes to the data then and there at the same time. My issue is that while I am HAPPY to read and learn how to do this, I have no idea where to start. What language this would be done in? Where can I go to read and learn how to incorporate an SQL database into a web page? What are some software packages I would need to employ in order to do this? - I wrote straight up HTML back in the day, but I haven't done anything with the web in about 10 years. All I know is buzzwords - css, php, html5?, I don't know... I'm lost here.
3 - Allow users who have loaded this internal website to make changes to this data that will write back to the SQL database.

My company will be installing MS SQL Server Developer for me to do this - what other software might I need on the SQL side to be able to do what I'm trying to do?

gbritton
Aged Yak Warrior

761 Posts

Posted - 08/26/2014 :  11:06:00  Show Profile  Reply with Quote
You will need Visual Studio. Probably your best bet is to build an ASP.NET MVC 4 application using SQL on the back end. There are good, free tutorials on ASP.NET MVC 4 available from Microsoft.

At a minimum, you will need to know:

1. SQL Server: How to design, develop and maintain databases
2. ASP.NET MVC: how to design web apps (intranet in your case) using ASP.NET MVC
3. C# (or Visual Basic or even F# if you're functionally minded)

Depending on where you're starting from, you have quite a journey ahead!

Here are some links to get you started:

http://www.sqlservercentral.com/stairway/72899/
http://www.sqlservercentral.com/stairway/72400/
http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/intro-to-aspnet-mvc-4
http://msdn.microsoft.com/en-us/library/aa288436(v=vs.71).aspx
Go to Top of Page

lordterrin
Starting Member

4 Posts

Posted - 08/26/2014 :  11:07:39  Show Profile  Reply with Quote
Thank you so much - this is all i wanted to know. :) I understand it's a large undertaking, but I have the time, and the desire to learn, and I feel Excel has gotten me very far, but I really need to move away from it and learn something new that has more functionality. I really appreciate your help!
Go to Top of Page

lordterrin
Starting Member

4 Posts

Posted - 08/28/2014 :  13:34:33  Show Profile  Reply with Quote
I got MySQL Server installed, as well as XAMPP. I'm not sure why I need both of these programs. I've messed around a bit with XAMPP, through the PHPmyAdmin and I'm comfortable doing basic dba (creating stuff, adding and deleting stuff... etc.) The part that I know nothing about is how to take this database I'm making and make a web front end for it. Now that I have an SQL server running on my localhost, how do I write something to utilize that, and where do I PUT that? Is localhost my server? I'm confused...
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36907 Posts

Posted - 08/28/2014 :  13:39:43  Show Profile  Visit tkizer's Homepage  Reply with Quote
I'm confused why you installed MySQL if your company is providing MS SQL Server Developer.

Regarding the frontend, that's where C# and ASP.NET comes into play.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

lordterrin
Starting Member

4 Posts

Posted - 08/28/2014 :  13:43:37  Show Profile  Reply with Quote
I explained what I needed, and our IT guy recommended MySQL over the Microsoft solution, (I'm assuming since it's free and all.) I realize this sounds like a stupid question, but web stuff is not my forte. Even if this exists only through my machine - how do I "load" a webpage onto my localhost so I can access it, so I can write something to access the database that I've just created?
Go to Top of Page

gbritton
Aged Yak Warrior

761 Posts

Posted - 08/28/2014 :  15:07:38  Show Profile  Reply with Quote
MySQL is probably just fine. Are you going to build your apps using Visual Studio (ASP.NET MVC4 in C#)? If so, you'll be hosting in IIS. If not, you'll have to take this whole discussion to another forum.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36907 Posts

Posted - 08/28/2014 :  15:41:03  Show Profile  Visit tkizer's Homepage  Reply with Quote
Even if it's IIS, the questions will be better answered on a forum specializing in the programming language in use. SQLTeam's core expertise is Microsoft SQL Server.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000