[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 434
  • Last Modified:

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?



0
pantoner
Asked:
pantoner
  • 3
  • 3
  • 2
1 Solution
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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:
You can use the Internet Control activeX.
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now