importing data from web page

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

The thing is that I am trying to import data from already existing html pages.

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

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

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.

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

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.