Solved

importing data from web page

Posted on 2001-08-21
8
397 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
ID: 6411860
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
ID: 6411883
The thing is that I am trying to import data from already existing html pages.
0
 
LVL 2

Expert Comment

by:tewald
ID: 6411903
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:pantoner
ID: 6411928
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
 
LVL 6

Accepted Solution

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

Expert Comment

by:xSinbad
ID: 6411962
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
ID: 6412019
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
ID: 6412335
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

789 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