Access Database and Rss Feeds

[Michael]

Hello, I am looking for some information on how to capture RSS feeds and to
store them in a Microsoft Access database. Specifically I would like to:
1) Set up the feed
2) Capture the feed Information ( Date, Topic,URL, Comopany, Summary and
other feed information)
3) Store the feed information in a table and then be able to sort by date,
company and other data elements.

Has anyone out there tried to do this using Macros or specific MS-Basic
programming? Thanks in advance for your support

 

[James A. Fortune]

Hello, I am looking for some information on how to capture RSS feeds and to
store them in a Microsoft Access database. Specifically I would like to:
1) Set up the feed
2) Capture the feed Information ( Date, Topic,URL, Comopany, Summary and
other feed information)
3) Store the feed information in a table and then be able to sort by date,
company and other data elements.

Has anyone out there tried to do this using Macros or specific MS-Basic
programming? Thanks in advance for your support

Here's the blurb from a PDC 05 presentation:

DAT320: Windows Vista: Building RSS Enabled Applications
Speakers: Amar Gandhi
Windows Vista adds support for RSS (Really Simple Syndication). The
RSS functionality in Windows Vista is being designed to make it simple
for end users to discover, view and subscribe to RSS feeds, as well as
make it easier for developers to incorporate the rich capabilities of
RSS into their applications. In addition, the RSS functionality
includes Simple List Extensions, a set of extensions to RSS that can
be used to enable Web sites to publish lists such as of photo albums,
music playlists and top 10 lists as RSS feeds. Come see multiple
examples of subscription-enabled applications built on the RSS APIs.
Security safeguards are also explained.

On:

http://msdn.microsoft.com/en-us/windows/default.aspx

I Bing'ed: DAT320

The link to a DAT320 download was broken :-(, but I discovered:

Introducing the Windows RSS Platform [API]

http://msdn.microsoft.com/en-us/library/ms686418(VS.85).aspx

I have a zipped file of the DAT320 presentation (147 MB) on my hard
drive, but I'm not sure it would be legal or even advisable to make it
publicly available. Hopefully, the API has what you are looking for.

James A. Fortune
(e-mail address removed)

 

[Douglas J. Steele]

I just answered a question on this yesterday at UtterAccess

 

[Douglas J. Steele]

Oops. That got sent too soon.

I just happened to answer a question on this topic yesterday at Utter Access

http://www.utteraccess.com/forums/s...15908&Zd=l&Zn=&Zt=3e8&Zs=&Zy=#Post1902837&Zp=

 

[James A. Fortune]

Oops. That got sent too soon.

I just happened to answer a question on this topic yesterday at Utter Access

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=83&Number=1...

Nothing beats a good code sample. IMO, MichKa's code was not
developed enough to make a copyright notice ethical, but it could come
into play if someone gets a software patent for the use of API
functions from VBA. I should post some samples of using .NET
functions from VBA also in case someone goes for that patent as
well .

James A. Fortune
(e-mail address removed)