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  8599 
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.
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
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
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]
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]
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?
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
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
"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
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
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.
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.
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]
"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.
"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!
"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)
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
'---------------
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
"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
"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
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
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
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
"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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Bo |
last post by:
Hi
The rectangles I draw in paint() always hide underneath the "Select
one to launch" screen, while the string "Hello World" is drawn over
the...
|
by: Stan Brown |
last post by:
The page
http://w3development.de/css/hide_css_from_browsers/media/
suggests using
@media all {
}
around rules to hide them from older browsers....
|
by: PeterK |
last post by:
Hi,
I am trying to install Visual Studio .Net 2003 (Academic Edition) on my PC
with a 64 bit AMD processor.
This is what happens:
1. The...
|
by: Ryan |
last post by:
Hello, I have a c++ application and I would like to simply play a
short video clip (mpg file) as a splash screen when the application
first begins...
|
by: u::l |
last post by:
Hi
I would like to ask directions regarding the creation of a screen that will
pop up when a user logs in.
He'll have to accept the terms of usage...
|
by: simon |
last post by:
hello,
i have a section of a page that has multiple dropdowns.
each dropdown calls the same method on a change of selection by the
user. the...
|
by: Simon Verona |
last post by:
I have a usercontrol which when entered pops up a form. I want the form to
be aligned with the bottom edge of the user control.
I was doing this...
|
by: fischermx |
last post by:
My software should take snapshots from the current screen from an icon
in the try area.
I need to programmatically emulate what the "print-screen"...
|
by: Kemmylinns12 |
last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
|
by: jalbright99669 |
last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
|
by: Matthew3360 |
last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function.
Here is my code.
...
|
by: Arjunsri |
last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
|
by: Matthew3360 |
last post by:
Hi,
I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
|
by: Oralloy |
last post by:
Hello Folks,
I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA.
My problem (spelled failure) is with the...
|
by: Carina712 |
last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
|
by: BLUEPANDA |
last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
|
by: Rahul1995seven |
last post by:
Introduction:
In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...
| |
