Role of Excel/Access in SQL Server 2008 R2

62,455 pts.
Tags:
Microsoft Access
Microsoft Excel
SQL Server 2008 R2
What is the role of Excel / Access in SQL Server 2008 R2?
ASKED: May 3, 2010  10:12 PM
UPDATED: May 4, 2010  2:27 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

PowerPivot for Excel is an free Excel Add-in that allows you to easily access data from diverse data sources, easily mashup data within Excel, process large volumes of data (millions to hundreds of millions of rows), use native Excel capabilities to analyze the data. With PowerPivot for SharePoint – which requires SQL Server 2008 R2 installed with SharePoint 2010 – users can publish their PowerPivot Workbooks to SharePoint in the PowerPivot Gallery. They are easily accessed and rendered via Excel Services; data is refreshed via a pre-determined schedule. Additionally – Reporting Services reports can be rendered as ATOM data feeds to PowerPivot for Excel. Providing an efficient means of delivering data in Excel for analysis.

——–

In other words, Excel provides a very powerful front end to allow users to download large amounts of data from the database and process that data into interactive charts and office based applications.

Access doesn’t have any specific functions with SQL Server 2008 R2. Access can still be used as a front end for a SQL Server database.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ITKE
    [...] Role of Excel/Access in SQL Server 2008 R2 asked via e-mail and answered by [...]
    0 pointsBadges:
    report
  • ITKE
    [...] Role of Excel/Access in SQL Server 2008 R2 asked by a reader and answered by [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following