Can’t see “Import Reports” in SQL Server Reporting Services Report designer

SSRS offers the ability to import Access reports via the Import Reports menu item off of the Project menu.


In SSRS 2005, you must have at least Access 2002 installed for the item to appear…which I do. So, I was confused when I couldn’t get the option to show up for me.


Well, after some playing around,  I found that it’s not good enough to just have Access 2002+ installed – it must also be registered as the current “runnable” version of Access.


For reasons I won’t get into here, I have multiple versions of Access installed on my machine, and whichever version was last run will be registered as the “current” version installed on the box. I had happened to run Access 2000 many moons ago, so when the VS IDE opened, it didn’t “know” that 2003 was installed too.


Just shut down VS, run Access 2003, then re-open VS…problem solved.

Comments (3)

  1. Alan says:

    Thanks very much for that!

    I wonder why it doesn’t use the registry to check which versions are installed…  Or why they don’t mention in their docs that you might have a problem with it.

    Many developers have more than one copy of Access installed, and there are enough ‘little issues’ to sink a ship.  Shame they don’t highlight them cos it’s these little things that cost the most time, for no really justifiable reason!

  2. myName says:


    Thanks for the tip.

    Do you have an idea if we can import reports from other proprietary reporting tools as well?


  3. No. We don’t give you this functionality (it would be nice, though!)