O'Reilly logo

Access Data Analysis Cookbook by Wayne S. Freeze, Ken Bluttman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating an RSS Feed

Problem

How can I create an RSS feed in Access?

Solution

Really Simple Syndication (RSS) RSS is an XML-based format aimed at content distribution. It's typically used to let people know about updates when content is added to a web site. RSS provides an easy way to package and distribute your most recent changes.

If you dig deep enough, you'll find that an RSS feed is nothing but an XML file structured according to a specific set of rules. Unfortunately, there are many different sets of rules, some of which are compatible and some of which are not. I won't debate the merits of one format over the other, but will simply use version 2, which is compatible with virtually all RSS tools.

In RSS, you typically create an XML document containing summary information about the blog or other Internet site for which you want to provide a content distribution feed. Here's a sample RSS file. This represents the minimum you really need to put in the file:

	<?xml version="1.0" ?>
	<rss version="2.0">
	<channel>

	  <title>Blog title</title>
	  <link>Blog URL</link>
	  <description>Description of the Blog</description>

	  <item>
	    <title>article title</title>
	    <link>article link</link>
	    <description>Description of the article</description>
	    <pubDate>Thu, 2 Feb 2006 19:21:36 CST</pubDate>
	  </item>
	</channel>
	</rss>

The file begins with the normal XML header, followed by an <rss> tag. The <rss> tag indicates the version of RSS used in this document. Inside the <rss> tag is a <channel> tag, which contains ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required