Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Save RSS feed into Access DB

Posted on 2004-11-02
Medium Priority
Last Modified: 2012-08-13
i parse rss feeds from another websites in my asp page... all is well, but is there away to save the rss feed in my access database?
Question by:Doomish
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

eyeh8u earned 200 total points
ID: 12481153
Do you want to save the raw RSS data, or the parsed result?

Saving the raw data is easy, assuming an access database with one table RSSfeeds with an autonumber id field and a text field called rssdata.

<%@ LANGUAGE = VBScript%>
Option Explicit

Dim objConn, objComm, objRS, strSQL, strConnectionString, strRSSData

strRSSData = loadrssfeed("http://www.somesite.com/feed.rss")

strConnectionString = "driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("../path/to/mdb") & ";"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnectionString
Set objComm = Server.CreateObject("ADODB.Command")
objComm.ActiveConnection = objConn
Set objRS = Server.CreateObject("ADODB.Recordset")

strSQL = "SELECT id, rssdata FROM rssfeeds WHERE id=-1"
objComm.CommandText = strSQL
objRS.Open objComm,,0,3
objRS("rssdata") = strRSSData

Set objRS = Nothing
Set objComm = Nothing
Set objConn = Nothing

If you are wanting to store the parsed results, it's the same thing really, but for each article in the feed you'd do an addNew and set objRS("title") = strArticleTitle etc before the update.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Client Need Led Us to RSS I recently had an investment company ask me how they might notify their constituents about their newsworthy publications.  Probably you would think "Facebook" or "Twitter" but this is an interesting client.  Their cons…
Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question