SQL Server Reporting Services Reports in Access



Using Access 2007 and SQL Server 2008.

Is there a way to display SQL Server Reporting Services reports in Access
If so, links to documentation/examples would be appreciated.

Charles Wang [MSFT]

Hi AG,
No,there is no compatible interface for converting SSRS report to Access
2007 now.You may consider first export your SSRS report to an Excel file
and then embed an OLE object "Microsoft Office Excel 97-2003 Worksheet". If
you only need the data, you can directly import data from Excel to your
Access database.

Best regards,
Charles Wang

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question