Thursday, March 10, 2016

Converting MS Access Reports to SQL Server Reporting Services Reports

I learned a neat trick from one of my colleagues today, something I wasn’t aware that it was even possible.

Did you know that you can take an existing MS Access report and convert it to a SQL Server Reporting Services(SSRS) report? Me neither! And it fact, it’s quiet easy. Let me show it…

  • Create a new SSRS project using the SQL Server Data Tools for BI(SSDT).

image

  • Click on the PROJECT menu item, choose Import Reports and click on the Microsoft Access… menu item.

image

  • Select the Access application you want to load the reports from and click OK.

image

  • That’s it!

Remark: Note that it is still possible you have to fix some errors after the import because not all Microsoft Access Report features are supported in SSRS.

1 comment:

williamson david said...

This is good guidance for converting MS access report to SQL server report.

Microsoft Access to SQL Server Migration