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
enter it into an Access table?
Thanks for all help?
Steve
PC Datasheet
D
Douglas J. Steele
Take a look at my November, 2003 Access Answers column in Pinnacle
Publication's Smart Access for one approach. You can download the article
and accompanying database at
http://members.rogers.com/douglas.j.steele/SmartAccess.html
Publication's Smart Access for one approach. You can download the article
and accompanying database at
http://members.rogers.com/douglas.j.steele/SmartAccess.html
M
Mike Turco
PC Datasheet said:
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
D
Darryl Kerkeslager
Mike Turco said:
LOL
Steve - now don't you regret asking for advice?
P
PC Datasheet
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.
Steve
L
Larry Linson
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.
D
Duane Hookom
what a hoot!
--
Duane Hookom
MS Access MVP
--
Duane Hookom
MS Access MVP
Larry Linson said:
M
Mike Turco
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
M
Marshall Barton
Mike Turco wrote:
[snip helpful part]
Marvelous!
What goes around, comes around, eh Steve ;-)
[snip helpful part]
Marvelous!
What goes around, comes around, eh Steve ;-)
R
Rob Oldfield
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.
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.
P
PC Datasheet
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
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
D
Darryl Kerkeslager
PC Datasheet said:
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
L
Lyle Fairfield
PC said:
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.
P
PC Datasheet
And what are you going to do since you only make smart remarks and don't
answer many posts?
answer many posts?
L
Larry Linson
"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
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
R
Randy Harris
Larry Linson said:
On the money! On all counts.
Randy Harris
tech at promail dot com
J
John Mishefske
You could just contact that server with your own HTTP request. NotPC said:
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.
T
Trevor Best
PC said:
Ah, but he doesn't top-post, top posters will go straight downstairs
D
David Schofield
What's top posting?
David
David
Ah, but he doesn't top-post, top posters will go straight downstairs
T
Trevor Best
David said:
A: Top-Posting
Q: What's the most annoying thing on usenet?