A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Screen Scrape"



 
 
Thread Tools Display Modes
  #1  
Old January 22nd, 2005, 05:45 PM
PC Datasheet
external usenet poster
 
Posts: n/a
Default "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


  #2  
Old January 22nd, 2005, 06:02 PM
Douglas J. Steele
external usenet poster
 
Posts: n/a
Default

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....artAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"PC Datasheet" wrote in message
nk.net...
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




  #3  
Old January 22nd, 2005, 07:19 PM
Mike Turco
external usenet poster
 
Posts: n/a
Default



"PC Datasheet" wrote in message
nk.net...
Does anyone know how to do a "screen scrape" to get data off a website and
enter it into an Access table?


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




  #4  
Old January 22nd, 2005, 08:18 PM
Darryl Kerkeslager
external usenet poster
 
Posts: n/a
Default

"Mike Turco" wrote
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).


LOL

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




  #5  
Old January 22nd, 2005, 09:01 PM
PC Datasheet
external usenet poster
 
Posts: n/a
Default

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


"Darryl Kerkeslager" wrote in message
...
"Mike Turco" wrote
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).


LOL

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






  #6  
Old January 22nd, 2005, 10:21 PM
Larry Linson
external usenet poster
 
Posts: n/a
Default

"PC Datasheet" wrote

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.


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.


  #7  
Old January 22nd, 2005, 11:49 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

what a hoot!

--
Duane Hookom
MS Access MVP


"Larry Linson" wrote in message
...
"PC Datasheet" wrote

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.


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.




  #8  
Old January 23rd, 2005, 12:37 AM
Mike Turco
external usenet poster
 
Posts: n/a
Default



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.


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



  #9  
Old January 23rd, 2005, 12:38 AM
Marshall Barton
external usenet poster
 
Posts: n/a
Default

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


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).



Marvelous!

What goes around, comes around, eh Steve ;-)

--
Marsh
MVP [MS Access]
  #10  
Old January 23rd, 2005, 12:58 AM
Rob Oldfield
external usenet poster
 
Posts: n/a
Default

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.


"Mike Turco" wrote in message
news:4tBId.13327$nt.10704@fed1read06...


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.


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





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Jump from Blank screen to slide N during presentation Yohs Powerpoint 3 December 30th, 2004 08:23 PM
Excel should allow me to screen scrape the data only Les Ferrington General Discussion 4 October 18th, 2004 02:25 AM
Blue Screen; Can't write to drive C: Felipe Quezada General Discussions 0 October 1st, 2004 04:32 PM
Some Screen Tips Are Missing [email protected] Setup, Installing & Configuration 3 June 28th, 2004 09:27 PM
Print Screen Issues with Dropdowns JulieD Worksheet Functions 0 June 1st, 2004 04:47 PM


All times are GMT +1. The time now is 03:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.