473,884 Members | 2,397 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

"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 #1
73 8959
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" <no****@nospam. spam> wrote in message
news:tq******** ********@newsre ad3.news.pas.ea rthlink.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

Nov 13 '05 #2


"PC Datasheet" <no****@nospam. spam> wrote in message
news:tq******** ********@newsre ad3.news.pas.ea rthlink.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


Nov 13 '05 #3
"Mike Turco" <mi*******@yaho o-no-spam-4-me.com> 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?

;)
Nov 13 '05 #4
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" <Ke*********@co mcast.net> wrote in message
news:FM******** ************@co mcast.com...
"Mike Turco" <mi*******@yaho o-no-spam-4-me.com> 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?

;)

Nov 13 '05 #5
"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.
Nov 13 '05 #6
PC Datasheet wrote:
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


Your reply reminds me of this technical article:

http://www.btjonline.com/stories/0404feature.shtml

Lyle

BTW, my spell checker chokes on Datasheet so I just click "Ignore".
.... hmmmmmmm ....
Nov 13 '05 #7
what a hoot!

--
Duane Hookom
MS Access MVP
"Larry Linson" <bo*****@localh ost.not> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..
"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.

Nov 13 '05 #8

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.m arketing.modera ted, misc.business.c onsulting or
alt.computer.co nsultants.moder ated. (FWIW, I moderate two of those three
groups.)

IMHO.

Mike

Nov 13 '05 #9
>"PC Datasheet" <no****@nospam. spam> 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]
Nov 13 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2375
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 "to launch" screen. What am I doing wrong? jdk 1.4, midp 2.0 public class myCanvas extends Canvas{
5
6693
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. Suppose the above occurs in a style sheet that was linked from my HTML via <link media="screen" ...>
0
1300
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 install process installs the prerequisites -> ok 2. The install process starts copying approx. 90 files to harddisk -> ok 3. The install process starts install scripts. At about 2/3 of the scripting process the machine simply REBOOTS!!!
1
2432
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 to execute. I seem to be having trouble so far. I believe I can use the MCI functions by doing the following: //code starts here// #include "stdafx.h" #pragma comment(lib, "vfw32.lib") HWND m_Player;
1
1511
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 (a lab we are running). If he accepts he can continue using windows or else he will be logged out (automatically will be the best. But evan a registry entry would be fine)
4
4480
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 method loops over all the dropdowns and if the newly selected items matches a previously set item, it changes the dropdown's background color from white to yellow and nulls out the previous selections value. this is working just fine functionally, but every postback causes the screen to refresh and...
1
27121
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 passing the usercontrol into the form as a parameter and using the left and top properties to find the location on the screen to position the form. However, these are relative to the container (panel/form/tabcontrol etc). How can I best locate or pass the actual screen coordinates of my...
1
4433
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" keyword does. How do I do that ? Thanks in advance,
0
9954
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9799
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11168
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10769
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10426
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7985
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7137
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
6009
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4623
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.