Solved

importing data from web page

Posted on 2001-08-21
8
375 Views
Last Modified: 2012-05-07
How can I import data from a web page into an access database? What technology should I be looking at to do this?



0
Comment
Question by:pantoner
  • 3
  • 3
  • 2
8 Comments
 
LVL 2

Expert Comment

by:tewald
Comment Utility
Your best bet for Access is Active Server Pages (a server-side scripting technology).  Here is a good resource/tutorial for ASP from Microsoft:

http://msdn.microsoft.com/library/default.asp?URL=/library/en-us/dnasp/html/asptutorial.asp

tewald
0
 

Author Comment

by:pantoner
Comment Utility
The thing is that I am trying to import data from already existing html pages.
0
 
LVL 2

Expert Comment

by:tewald
Comment Utility
I'm not sure I understand.  What is the current state of these html pages?  Are there already forms on these pages that a user inputs information into, or are you interested in incorporating this type of functionality into existing pages?  If this functionality already exists, does the submission of data go to another type of database (rather than Access)?
0
 

Author Comment

by:pantoner
Comment Utility
For example. Let's say that I wanted to import the data from this page into an access database.
 
http://www.drf.com/charts/17/ccrc17.html
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 6

Accepted Solution

by:
xSinbad earned 50 total points
Comment Utility
You can use the Internet Control activeX.
0
 
LVL 6

Expert Comment

by:xSinbad
Comment Utility
But looking at that page you are going to get a lot of other junk as well. The Inet Control will import all the HTML as well as the text you are after. It would take some clever code strip it all clean.
0
 
LVL 2

Expert Comment

by:tewald
Comment Utility
xSinbad is right.  The info you'd want to import isn't in a format that is readily condusive to parsing and importing into a database.  I'd imagine that the format of the results posted on that site will not be consistent either (i.e. varying number of race horses); therefore, the job becomes even more difficult.

You're probably looking for a quick/trick answer but I'm afraid there isn't one.  Maybe you could copy the the data on the page, paste it as HTML into Excel, and run a macro to format the data so it is easy to upload into a database. Not 100% automated unfortunately.

tewald
0
 

Author Comment

by:pantoner
Comment Utility
Thanks also to tewald for your help. I was just looking to shine some light onto my problem and you have done that for me.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now