importing data from web page

How can I import data from a web page into an access database? What technology should I be looking at to do this?



pantonerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
xSinbadConnect With a Mentor Commented:
You can use the Internet Control activeX.
0
 
tewaldCommented:
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
 
pantonerAuthor Commented:
The thing is that I am trying to import data from already existing html pages.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
tewaldCommented:
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
 
pantonerAuthor Commented:
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
 
xSinbadCommented:
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
 
tewaldCommented:
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
 
pantonerAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.