Have been tasked with the project of creating reports from excel source and displaying to users after our DBA left in a huff. I have basic experience working on SQL mostly admin work but have not worked on the reporting aspect at all.
Our reports run on SQL Server 2005. The other reports just display data to the users through a webpage. They click on a link which asks them to select the report they want to see and it displays it. No inputs are required from user. The sources tend to be Excel files which are updated on a regular basis and this must be reflected on the reports. The DBA has a created a database for reporting and has tables in it from which reports are linked/pulled.
Where do I look for the source of these excel files through SQL Mgmt Studio? Do I need to create a linked server since the sources are on another physical server? What other information can I furnish you guys?
I am hoping to try to copy the method that he has used so that I can figure this out better till we get some additional help for Reporting. Any suggestions? TIA