469,330 Members | 1,373 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,330 developers. It's quick & easy.

"Screen Scrape"

Does anyone know how to do a "screen scrape" to get data off a website and
enter it into an Access table?

Thanks for all help?

Steve
PC Datasheet
Nov 13 '05
73 8400
Lyn
Chris,
Thanks for the reference to the RFC which I have bookmarked. I think it
covers all the questions I was asking. Although as someone has pointed out
it is getting a little dated now. I was interested to note that in the
links to Comments on the RFC (which I have not yet read), the debate about
top vs bottom is alive and well, even there!

--
Cheers,
Lyn.

"Chris2" <ra******************@GETRIDOF.luminousrain.com> wrote in message
news:e-********************@comcast.com...

Lyn,

RFC1855: Netiquette Guidelines, http://www.faqs.org/rfcs/rfc1855.html,
mandates bottom-posting.
<SNIP>
Sincerely,

Chris O.

Nov 13 '05 #51
Lyn wrote:
I think that the reason I usually top post is that a posting is like
replying to an email -- in emails you normally put your reply at the top of
any part of the email that you are replying to (at least in the business
world that I belonged to this was so). Indeed, mail clients that I have
used default the cursor to the top when replying, so it is easy and natural
to reply this way. And some of these mail clients are also news clients
which also put the cursor at the top. As someone pointed out, top posting
makes it easy to browse quickly through a thread via the preview pane to get
the gist without having to scroll every message.
Mozilla Thunderbird will pop the cursor down the bottom for you, in mail
as well as news, although this is configurable for both. It gives you a
choice of style (or a choice of which camp to upset:). The MS offerings
give you no such choice, you are expected to post in the MS style (which
when it came out was contrary to everyone else's), expect to see MS'
offices change into a Borg cube anytime soon.
Perhaps the most important thing in this issue (which I don't think anyone
has mentioned, apologies if I am wrong), is not to MIX top and bottom
posting in a long thread! I have seen examples of this and it is most
confusing to follow the thread. I think that the rule should be that if an
established thread is either top or bottom, additional postings should
respect that -- unless the original postings have been trimmed to the point
that it doesn't matter anymore.


Will never happen, as you can see you top posted, but I am commenting on
particular parts of your post, not possible with top posting unless I
word my post to include most of what you wrote.

--
This sig left intentionally blank
Nov 13 '05 #52
Lyn wrote:
Chris,
Thanks for the reference to the RFC which I have bookmarked. I think it
covers all the questions I was asking. Although as someone has pointed out
it is getting a little dated now.


So none of the 10 commandments have relevance anymore? Think I'll go out
and kill someone today and covert my neighbor's wife.

--
This sig left intentionally blank
Nov 13 '05 #53
On Tue, 25 Jan 2005 06:01:30 +0000, Trevor Best <no****@besty.org.uk>
wrote:
expect to see MS'
offices change into a Borg cube anytime soon.


www.microsith.com

John W. Vinson[MVP]
Nov 13 '05 #54
On Tue, 25 Jan 2005 05:37:06 GMT, Tony Toews <tt****@telusplanet.net>
wrote:
John Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
This argument has been going on as long as Usenet has existed.


For those of us from BBSs and/or Fidonet it was defiitely trim and bottom post.

Tony


It was customary on ARPANet back when that consisted of twelve
university computers too.

John W. Vinson[MVP]
Nov 13 '05 #55
LOL! you got me, I didn't notice the cross-posting.

Trouble is once you start replying to a crosspost it's difficult to stop as
you don't know where people are replying from.
--
Terry Kreft
MVP Microsoft Access
"rkc" <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in message
news:uu********************@twister.nyroc.rr.com.. .
Terry Kreft wrote:
People can get quite vehement about top and bottom posting.


What about eliminating newsgroups from a multi-posted article
when replying?

Nov 13 '05 #56
I thought it was covet your neighbours wife, but times change I suppose, if
you want to hide your neighbours wife then you go for it Trevor!

--
Terry Kreft
MVP Microsoft Access
"Trevor Best" <no****@besty.org.uk> wrote in message
news:41***********************@news.zen.co.uk...
Lyn wrote:
Chris,
Thanks for the reference to the RFC which I have bookmarked. I think it
covers all the questions I was asking. Although as someone has pointed out it is getting a little dated now.


So none of the 10 commandments have relevance anymore? Think I'll go out
and kill someone today and covert my neighbor's wife.

--
This sig left intentionally blank

Nov 13 '05 #57
It was <g>.

--
Terry Kreft
MVP Microsoft Access
"Tony Toews" <tt****@telusplanet.net> wrote in message
news:0n********************************@4ax.com...
John Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
This argument has been going on as long as Usenet has existed.
For those of us from BBSs and/or Fidonet it was defiitely trim and bottom

post.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 13 '05 #58
"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:j9********************************@4ax.com...
On Tue, 25 Jan 2005 05:37:06 GMT, Tony Toews <tt****@telusplanet.net>
wrote:
John Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
This argument has been going on as long as Usenet has existed.


For those of us from BBSs and/or Fidonet it was defiitely trim and bottom post.
Tony


It was customary on ARPANet back when that consisted of twelve
university computers too.

John W. Vinson[MVP]


Omigod say it ain't so! FidoNet, yes, but ARPANet!?! I thought you people
were part of the Great Generation that was all gone <g>
Darryl Kerkeslager


Nov 13 '05 #59
Tony Toews wrote:
John Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
This argument has been going on as long as Usenet has existed.


For those of us from BBSs and/or Fidonet it was defiitely trim and
bottom post.

Tony


As with most things in life context has a lot to do with it (IMO). *Discussion*
groups with threads that go on and on (and on) should most definitely impose a
bottom-post-only protocol otherwise it's a nightmare.

One must always remember that the way *your* newsreader presents a thread to
*you* is not how it is presented to everyone else. The attitude of "If someone
wants to see what I am talking about they can look at previous posts" doesn't
cut it. A post should make (some) sense all by itself.

In *technical* groups where a question is asked and answered it simply doesn't
make enough difference to get worked up about, but I still bottom post (mostly)
because you never know when a thread will turn into a discussion.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #60
Lyn
I was actually planning to try out Thunderbird, as soon as I can get enough
time online to download the 6 MB file over my dialup line!

--
Cheers,
Lyn.

"Trevor Best" <no****@besty.org.uk> wrote in message
news:41***********************@news.zen.co.uk...

Mozilla Thunderbird will pop the cursor down the bottom for you, in mail
as well as news, although this is configurable for both.

Nov 13 '05 #61
Whether one top-posts or bottom-posts - - - just simply isn't that
important!

This is one of those petty little arguments that people start when it's a
slow news day, or they got out of bed on wrong side, or they're trying to
intimidate someone new to the group. :-)

Look, what's really important is that when replying to a post, is that one
follows the preference of the majority of the newsgroup one is participating
in.

The majority for the newsgroup, comp.databases.ms-access, MOSTLY top-posts,
so there I generally top-post. The majority for the newsgroup
comp.lang.python bottom-posts, so there I bottom-post. When joining a
group, I usually lurk around long enough to find out what the majority
prefers, and develop a feel for group, then I just follow along. No biggy.

I don't have a preference either way; it's not that important to me. What
DOES irritate me, A LOT, is when replies include EVERY single previous reply
in the thread. This isn't context, this is waste of my time trying to find
out whether the reply-ee has anything important to add to the discussion, or
just feeding his/her ego with a long, long, long, etc., etc., etc. post. :-)

I do appreciate those people who intersperse their replies when appropriate,
especially when responding to individual points in the post. Some people
even go so far as to break this type of post into several smaller posts when
replying. Sometimes this is good, sometimes not.

The thing is, I appreciate all the answers and the help given by the
responders, and in the end, that's all that matters.

Ruben

"Chris2" <ra******************@GETRIDOF.luminousrain.com> wrote in message
news:e-********************@comcast.com...

"Lyn" <lh******@ihug.com.au> wrote in message
news:ct**********@lust.ihug.co.nz...
This may be straying from the original topic (but then who hasn't in this
thread :-), but I have a serious question. Like David, I didn't

understand
the reference to "top posting". Nor Trevor's response -- at first (but I
got it eventually :-).


Lyn,

RFC1855: Netiquette Guidelines, http://www.faqs.org/rfcs/rfc1855.html,
mandates bottom-posting.

"If you are sending a reply to a message or a posting be sure you
summarize
the original at the top of the message, or include just enough text of the
original to give a context. This will make sure readers understand when
they start to read your response. Since NetNews, especially, is
proliferated by distributing the postings from one host to another, it is
possible to see a response to a message before seeing the original.
Giving
context helps everyone. But do not include the entire original!"

That should be enough for anyone.
Sincerely,

Chris O.

Nov 13 '05 #62
On Tue, 25 Jan 2005 07:36:03 -0500, "Darryl Kerkeslager"
<Ke*********@comcast.net> wrote:
Omigod say it ain't so! FidoNet, yes, but ARPANet!?! I thought you people
were part of the Great Generation that was all gone <g>


<rapping my cane on the floor> Hey you young whippersnapper, let's
have some respect for your elders here! <g>

John W. Vinson[MVP]
Nov 13 '05 #63
"Ruben Baumann" <ry**@yahoo9.com> wrote in
news:J_********************@megapath.net:

"Lyn" <lh******@ihug.com.au> wrote in message
news:ct**********@lust.ihug.co.nz...
This may be straying from the original topic (but then who
hasn't in this thread :-), but I have a serious question.
Like David, I didn't understand
the reference to "top posting". Nor Trevor's response -- at
first (but I got it eventually :-).
Lyn,

RFC1855: Netiquette Guidelines,
http://www.faqs.org/rfcs/rfc1855.html, mandates
bottom-posting.

"If you are sending a reply to a message or a posting be sure
you summarize
the original at the top of the message, or include just enough
text of the original to give a context.
Whether one top-posts or bottom-posts - - - just simply isn't
that important!

This is one of those petty little arguments that people start
when it's a slow news day, or they got out of bed on wrong
side, or they're trying to intimidate someone new to the
group. :-)

Look, what's really important is that when replying to a post,
is that one follows the preference of the majority of the
newsgroup one is participating in.


Maybe it's not important to you. My time is precious to me. I
use a reader that shows messages in a treeview. By simply
clicking on the leaf node of a thread, I can get all the
information out of the thread that's relevant, but only if the
quotations have been judiciously snipped, and the responses are
bottom posted.

The majority for the newsgroup, comp.databases.ms-access,
MOSTLY top-posts, so there I generally top-post. The majority
for the newsgroup comp.lang.python bottom-posts, so there I
bottom-post. When joining a group, I usually lurk around long
enough to find out what the majority prefers, and develop a
feel for group, then I just follow along. No biggy.


I don't accept your comment about the majourity of this group's
replies being top posted. That is not the case.
[remainder snipped]

--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #64
"Trevor Best" wrote
So none of the 10 command-
ments have relevance anymore?
As I understand it, the political party to which you subscribe may have some
bearing on this.
Think I'll go out and kill someone
I'd suggest you wait and do so on a day when you haven't first posted your
intention on the Internet. Even if the Commandment does not apply, there are
laws against it in every jurisdiction where I have ever visited. And, over
here, they are decidedly "Old-Testmentish" in many of the States.
today and covert my neighbor's wife.


There's a lot of "coveting" going on, but you may have a real point about
the "covert" part -- especially if the neighbor is bigger and tougher than
you are!
Nov 13 '05 #65
"Larry Linson" <bo*****@localhost.not> wrote in message
news:MJDJd.19997$c%6.7013@trnddc03
"Trevor Best" wrote
> Think I'll go out and kill someone [...]
> today and covert my neighbor's wife.


There's a lot of "coveting" going on, but you may have a real point
about the "covert" part -- especially if the neighbor is bigger and
tougher than you are!


Just be sure that, no matter how much you covet her, you don't cover her
unless you do it covertly.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Nov 13 '05 #66
John Mishefske wrote:
PC Datasheet wrote:
Does anyone know how to do a "screen scrape" to get data off a website
and
enter it into an Access table?

Thanks for all help?

Steve
PC Datasheet

You could just contact that server with your own HTTP request. Not
terribly difficult to do and then you can decode the response in
code.

The WinInet library has a bunch of API calls to do just this.

Here's one resource:

http://www.mvps.org/access/modules/mdl0037.htm

--
'---------------
'John Mishefske
'---------------
Nov 13 '05 #67
Hi
If we all used tree-view readers like Google's we wouldn't need to
quote any of the original posts at all and most threads would fit on
one screen!
David

Nov 13 '05 #68
"David Schofield" <d.***************@blueyonder.co.uk> wrote
Hi
If we all used tree-view readers like Google's we wouldn't need to
quote any of the original posts at all and most threads would fit on
one screen!


What Google are you using? When I look in Google there is no tree view as
of a month or so ago.
Darryl Kerkeslager
Nov 13 '05 #69
"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1106700328.c09695b041362829287307247eeac91c@t eranews...

Maybe it's not important to you. My time is precious to me. I
use a reader that shows messages in a treeview. By simply
clicking on the leaf node of a thread, I can get all the
information out of the thread that's relevant, but only if the
quotations have been judiciously snipped, and the responses are
bottom posted.

Your right Bob, it's not that important to ME!, and yes, my time is
important too.

I do however, appreciate your reply.

The only thing of real importance to me is, do I get the answers I need when
I ask questions, and do I get useful information from the other questions
asked and answered in the ng. That's all that matters to me.
The majority for the newsgroup, comp.databases.ms-access,
MOSTLY top-posts, so there I generally top-post. The majority
for the newsgroup comp.lang.python bottom-posts, so there I
bottom-post. When joining a group, I usually lurk around long
enough to find out what the majority prefers, and develop a
feel for group, then I just follow along. No biggy.


I don't accept your comment about the majourity of this group's
replies being top posted. That is not the case.
--
Bob Quintal


You're certainly entitled to your opinion on this. I have to admit
"majority" is a probably a wrong choice of word here, but just browsing
through todays replies indicates that some people top-posted, some
bottom-posted, and it doesn't matter to me at all which way they did it,
just that I gleaned some useful info.

This is a religious, almost fanatical, issue for some, and fanaticism
regarding THIS issue, is a real issue for ME. Perhaps some day, I'll be
fanatical about how I and others post...but not this day. Call me heretic.
<G>

Ruben Baumann
Nov 13 '05 #70
On Wed, 26 Jan 2005 08:25:00 -0500, "Darryl Kerkeslager"
<Ke*********@comcast.net> wrote:
"David Schofield" <d.***************@blueyonder.co.uk> wrote
Hi
If we all used tree-view readers like Google's we wouldn't need to
quote any of the original posts at all and most threads would fit on
one screen!


What Google are you using? When I look in Google there is no tree view as
of a month or so ago.
Darryl Kerkeslager

Hi

does this work? Google hadn't yet got your post
http://groups.google.co.uk/groups?hl...ases.ms-access

I normally use free agent for posting but find google is much easier
for reading huge threads like this one (how pathetic that I have
nothing better to do!)
David

Nov 13 '05 #71
Larry Linson wrote:
> Think I'll go out and kill someone


I'd suggest you wait and do so on a day when you haven't first posted your
intention on the Internet. Even if the Commandment does not apply, there are
laws against it in every jurisdiction where I have ever visited. And, over
here, they are decidedly "Old-Testmentish" in many of the States.


Yup, those laws are still older than Usenet guidelines though :-)

Actually under British law, I can kill someone abroad and be safe if I
make it back here (unless the authorities here grant extradition)
although if I was to kill another Briton abroad I can be prosecuted for
it back in Britain.
> today and covert my neighbor's wife.


There's a lot of "coveting" going on, but you may have a real point about
the "covert" part -- especially if the neighbor is bigger and tougher than
you are!


Well you have to be covert about these things anyway, there is a fox
hole under the fence anyway :-)

--
This sig left intentionally blank
Nov 13 '05 #72
Dirk Goldgar wrote:
"Larry Linson" <bo*****@localhost.not> wrote in message
news:MJDJd.19997$c%6.7013@trnddc03
"Trevor Best" wrote
> Think I'll go out and kill someone [...]
> today and covert my neighbor's wife.


There's a lot of "coveting" going on, but you may have a real point
about the "covert" part -- especially if the neighbor is bigger and
tougher than you are!

Just be sure that, no matter how much you covet her, you don't cover her
unless you do it covertly.


Whipped cream or peanut butter?

--
This sig left intentionally blank
Nov 13 '05 #73

"David Schofield" <d.***************@blueyonder.co.uk> wrote
"David Schofield" <d.***************@blueyonder.co.uk> wrote
If we all used tree-view readers like Google's we wouldn't need to
quote any of the original posts at all and most threads would fit on
one screen!


What Google are you using? When I look in Google there is no tree view asof a month or so ago.

does this work? Google hadn't yet got your post
http://groups.google.co.uk/


Yes! This is how Google.com looked until a month or so ago, when all of a
sudden, the left treeview stopped showing, and was replaced by TWO search
boxes, one for the current group, one for all groups (which is annoying all
by itself). I suppose if I wan't "Classic Google" I will have to use the UK
site,

Thank you.
Darryl Kerkeslager
Nov 13 '05 #74

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Stan Brown | last post: by
1 post views Thread by Ryan | last post: by
1 post views Thread by fischermx | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.