Importing Access Reports into SQL Server Reporting Services
August 13, 2009[From SQL Server Magazine]
If you have Microsoft Access reports that need to be integrated into SQL Server Reporting Services, you can use the Access Report Import Wizard to convert Access reports into RDL. Before you begin the process of converting Access Reports to RDL, youll need Microsoft Access, Visual Studio (VS) 2008 SP1 or VS 2005, and the Access database file. Note that you can only convert Access reports that come from OLE DB data sources.
The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=102132