Import Reports from Microsoft Access (Reporting Services)
In Report Designer, you can import reports from a Microsoft Access database or project. Access 2002 or a later version must be installed on the same computer on which Report Designer is installed.
When you use the import feature, all reports in the database or project file are imported. If your Access file contains many reports, you may want to create a separate report project into which to import the reports, and then open the individual RDL files in your main report project. You can edit the reports after they are imported into Report Designer.
Reporting Services does not support all Access report objects. Items that are not converted are displayed in the Task List window. For more information, see Supported Access Report Features (SSRS).
To import reports from Microsoft Access
Open or create a project into which to import the reports.
On the Project menu, point to Import Reports, and then click Microsoft Access. Alternatively, right-click the project in Solution Explorer, point to Import Reports, and then click Microsoft Access.
In the Open dialog box, select the Access database (.mdb, .accdb) or project (.adp) that contains the reports, and then click Open. All the reports in the database or project file are imported and listed in the Reports folder in Solution Explorer.
Check the Task List window for build errors. To view the Task List window, open the View menu, point to Other Windows, and then click Task List.