"Screen Scrape"

  • Thread starter Thread starter PC Datasheet
  • Start date Start date
P

PC Datasheet

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
 
PC Datasheet said:
Does anyone know how to do a "screen scrape" to get data off a website and
enter it into an Access table?
Click to expand...

What are you looking for exactly? Are you trying to download data from
database? If so, I use the Internet Transfer Control from VB to connect to
and download the page. Then I parse out the data for which I'm looking. The
trick is in how you formulate the URL to query the database and get what you
want.

If you're just looking to download an entire page, you can just save the
data and store it in a memo field. Again, using the Internet Transfer
Control.

I am in business to provide customers with a resource for help with
Microsoft Access, Excel and Word applications. I can help you with this. If
you would like my help, contact me at my email address (take
out -nospam4me).

Mike
 
Mike Turco said:
I am in business to provide customers with a resource for help with
Microsoft Access, Excel and Word applications. I can help you with this. If
you would like my help, contact me at my email address (take
out -nospam4me).
Click to expand...

LOL

Steve - now don't you regret asking for advice?

;)
 
No, not at all!

If this is important enough for me to get this to work and I am not able to
get it myself, I now have a resource to go to for help. It's solely my
decision on whether I want to pay for the help but I have someone to go to
if I decide I want to pay.

Steve
 
If this is important enough for me to
get this to work and I am not able to
get it myself, I now have a resource
to go to for help. It's solely my
decision on whether I want to pay
for the help but I have someone to
go to if I decide I want to pay.
Click to expand...

Ah, Steve, surely you could not have missed Mike's point -- his is almost a
word-for-word copy of what you use to flog your for-pay service in the
newsgroup. Have a nice day.
 
what a hoot!

--
Duane Hookom
MS Access MVP


Larry Linson said:
Ah, Steve, surely you could not have missed Mike's point -- his is almost
a
word-for-word copy of what you use to flog your for-pay service in the
newsgroup. Have a nice day.
Click to expand...
 
Ah, Steve, surely you could not have missed Mike's point -- his is almost
a
word-for-word copy of what you use to flog your for-pay service in the
newsgroup. Have a nice day.
Click to expand...

There are two kinds of people on this group: available consultants and
potential customers. I would love to come to this group and say, "HEY
EVERYONE I CAN FIX IT HIRE ME!!!!". I just think that's inappropriate for
this group.

I've wanted, for some time, to add a sig line to my posts and use these
groups more frequently in hopes of getting the word out, but I don't. I'm
sure others feel the same way. Usenet, especially these tech groups, is not
a place where its acceptable to hock your wares.

Where to advertise? How to get the word out on what you do? That's off-topic
to this group. To answer that question I would suggest people try the
newsgroup misc.business.marketing.moderated, misc.business.consulting or
alt.computer.consultants.moderated. (FWIW, I moderate two of those three
groups.)

IMHO.

Mike
 
Mike Turco wrote:
[snip helpful part]
I am in business to provide customers with a resource for help with
Microsoft Access, Excel and Word applications. I can help you with this. If
you would like my help, contact me at my email address (take
out -nospam4me).
Click to expand...


Marvelous!

What goes around, comes around, eh Steve ;-)
 
I'd say it was OK to add a corporate website to your sig (e.g. Dirk) If I'm
interested then I can look further, if not, then I don't.

....and I'm neither of your two kinds by the way.... but I know what you
mean.
 
There are 40 unanswered posts from this past week prior to my post. Why
haven't you tried to help these folks? There is no reward in heaven for
criticizing me but much reward to gain by helping these folks.

Steve
 
PC Datasheet said:
There are 40 unanswered posts from this past week prior to my post. Why
haven't you tried to help these folks? There is no reward in heaven for
criticizing me but much reward to gain by helping these folks.

Steve
Click to expand...

Steve,

Please re-read my post. While I admittedly was enjoying a laugh (a very
good one) at your expense, I was not in any way being critical. I would
assume that in the many, many answers you have given in this NG, you have
probably answered some of mine (even if someone else actually asked the
question).

I do appreciate your time. I know how valuable time is.

But you must admit, he pegged you.



Darryl Kerkeslager
 
PC said:
There are 40 unanswered posts from this past week prior to my post. Why
haven't you tried to help these folks? There is no reward in heaven for
criticizing me but much reward to gain by helping these folks.
Click to expand...

If you answer enough questions God will let you sit around in a pink
robe on a white cloud with a couple of redheads for eternity, or until
one of them moans, which ever comes first.
 
And what are you going to do since you only make smart remarks and don't
answer many posts?
 
"Mike Turco" wrote
There are two kinds of people on
this group: available consultants and
potential customers. I would love to
come to this group and say, "HEY
EVERYONE I CAN FIX IT HIRE
ME!!!!". I just think that's inappro-
priate for this group.
Click to expand...

That is in accord with USENET guidelines and the FAQ for this newsgroup.
I've wanted, for some time, to add a
sig line to my posts and use these
groups more frequently in hopes of
getting the word out, but I don't. I'm
sure others feel the same way. Usenet,
especially these tech groups, is not
a place where its acceptable to hock
your wares.
Click to expand...

The people in this newsgroup, except some who'd gripe about anything and
troll when they aren't griping, have never objected to posters including a
moderate amount of contact information in a SIG (there's no absolute limit,
but 4 lines doesn't seem to be objectionable in most newsgroups).
Where to advertise? How to get the
word out on what you do? That's off-
topic to this group. To answer that
question I would suggest people try the
newsgroup misc.business.marketing.
moderated, misc.business.consulting or
alt.computer.consultants.moderated.
(FWIW, I moderate two of those
three groups.)
Click to expand...

Nor, have the people here (same exceptions) objected to a reference to a
commercial product when it is a specific and valid answer to a legitimate
question. Because so many people here do contract work for pay, and because
that isn't a specific answer to a question, many "non-gripers" have
complained about Steve's "I can help you for pay" responses.

Larry Linson
Microsoft Access MVP
 
Larry Linson said:
"Mike Turco" wrote


That is in accord with USENET guidelines and the FAQ for this newsgroup.


The people in this newsgroup, except some who'd gripe about anything and
troll when they aren't griping, have never objected to posters including a
moderate amount of contact information in a SIG (there's no absolute limit,
but 4 lines doesn't seem to be objectionable in most newsgroups).


Nor, have the people here (same exceptions) objected to a reference to a
commercial product when it is a specific and valid answer to a legitimate
question. Because so many people here do contract work for pay, and because
that isn't a specific answer to a question, many "non-gripers" have
complained about Steve's "I can help you for pay" responses.

Larry Linson
Microsoft Access MVP
Click to expand...

On the money! On all counts.

Randy Harris
tech at promail dot com
 
PC said:
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
Click to expand...
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.
 
PC said:
And what are you going to do since you only make smart remarks and don't
answer many posts?
Click to expand...

Ah, but he doesn't top-post, top posters will go straight downstairs :-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iterating through IP addresses on a server when screen scraping 11
Screen Scrape from Excel 1
Screen Scrape from Excel 1
RUMBA emulation 4
Holding session in HTTPWebRequest 3
Green screen scrape 5
Screen Scrape 5
Control Identity 2

Back
Top