SQL Server data mining

Question

Hi All,

I would like to import my Excel document to a database and then create reports and also show some of the information in a website. What do you recommend as a database that can be used easily on importing data from Excel to that and then create reports, etc. I need a separate web interface for importing data manually and also for showing the results to end users, right?

I have several sheets of information. It contains:

1. Concerts list
2. Musicians list
3. Albums list
4. Festivals list
5. Instruments list

The below link shows the relational database of my project. Needs to be updated but roughly it shows.

https://dbdiagram.io/d/5fe7854f9a6c525a03bc5a2c

Answer 1

Hi,

You could import your Excel data into SQL Server, and manage them in SQL Server database. Using such method as : Import data from Excel to SQL Server

Then using SSRS - the reporting service of SQL Server to create reports and show them to your end user .

I need a separate web interface for importing data manually

I have not quite understood how you get you data, were they not in Excel ? But of course you could get data from web interface and store them in SQL Server.

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November