in reply to RE: RE: RSS Headline Sucker
in thread RSS Headline Sucker
Wow, your code is exactly what I need. Cannot get it to run on Access though.
This is the content of my first table named ExternalNewsSources which has only one row at the moment.
Columns:
ExternalNewsSourceID
Title
Link
Description
Source
With data:
1
SlashDot
http://slashdot.org/
Headlines
http://slashdot.org/slashdot.rdf
Format of the first table is as suggested
ExternalNewsSourceID -> autoNumber (internal unique id)
Title -> text (name of the site)
Link -> text (link to the site, not the source)
Description -> text (description of the site)
Source -> text (URL for the actual feed)
My second table is named ExternalNews and has the following columns:
SourceID -text
PostDate -text
Title -text
Link -text
Description -text
I have a System DSN named TESTSERVER as in the example and I'm running your example code as published.
I don't get any errors.... just no data in the tables. Do I have something simple wrong?