SQL Server Performance

Importing MS Access Reports

Discussion in 'SQL Server 2005 Reporting Services' started by MichaelB, Feb 21, 2007.

  1. MichaelB Member

    I am new to RS, but I wanted to post this to share with those that dont know this fact. <br />RS imports MS Access reports extremely well. In our case, we have someone in the company that writes great MS Access reports and is a business leader who knows what he wants. Now he can whip out the reports he wants and we can drive them quickly to RS. Very little learning curve needed for this. If you have a similar situation, you are blessed![<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br /><br /><br />Michael <br />MCDBA<br /><br />"The fear of the Lord is the beginning of knowledge,<br />but fools despise wisdom and instruction." Proverbs 1:7
  2. satya Moderator

    Good to know that you have such process in place to migrate them smoothly, why don't you write an article in this regard on this site for more information.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. MichaelB Member

    I could contribute?<img src='/community/emoticons/emotion-1.gif' alt=':)' /> cool. who do I submit to?<br /><br />Michael <br />MCDBA<br /><br />"The fear of the Lord is the beginning of knowledge,<br />but fools despise wisdom and instruction." Proverbs 1:7
  4. dezBar New Member

    Hi...
    is there a way to connect to msSQL 2000 and create reports from msAccess or is this frowned upon in light of the Reporting Service?

    in advance, thanks.

    dezBar
  5. MichaelB Member

    totally do-able. I am about to go to a meeting.... I will revisit this.

    Michael
    MCDBA

    "The fear of the Lord is the beginning of knowledge,
    but fools despise wisdom and instruction." Proverbs 1:7
  6. MichaelB Member

    just use a linked table to the SQL data source and write your report.

    Michael
    MCDBA

    "The fear of the Lord is the beginning of knowledge,
    but fools despise wisdom and instruction." Proverbs 1:7

Share This Page