SQL Server Performance Forum – Threads Archive
Importing MS Access Reports
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
‘ />]<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
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.
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
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
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
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
]]>