[RESOLVED] Inputing into db from Website
I am running access 2003 vba and am trying to figure out the best approach for saving information from a website to my database.
The initial way I was working with is using the activex control for viewing websites on my forums and just a command button to initiate the code. I can view the website just fine but I do not know how to step through the website and put the information into workable information.
The website uses java and is not in any fixed format really. The length of the document changes based on the person.
Here is a small sample of the source of the website I am trying to work on:
Code:
<div class="details">
<span id="Quals" onclick="javascript: toggleTable(this.id)" class="OutlineIcon">
<img id="imgQuals" src="images/minusIcon.gif" border="0" WIDTH="14" HEIGHT="14"></span>
<span class="detailsHd">ATMS Quals</span>
<table id="tblQuals" border="1" cellpadding="2" cellspacing="0" class="details">
<tr><th>Qual Number</th>
<th>Title</th>
<th>Expires</th></tr>
<tr><td align="left" valign="top" class="Normal">
ADM_MAT </td>
<td align="left" valign="top" class="Normal">
<a href="atms_supv_qualtree.cfm;jsessionid=0e30e09a3ccb91f2c5ca5e806e7d2b2d6176?PID=22644&qualcat=ADM&qualid=_MAT&title=MANDATORY ANNUAL TRAINING" class="Normal">MANDATORY ANNUAL TRAINING </a></td>
<td align="center" valign="top" class="Normal">
10/31/2011 </td></tr>
<tr><td align="left" valign="top" class="Normal">
BASSHIP_WORKER </td>
<td align="left" valign="top" class="Normal">
<a href="atms_supv_qualtree.cfm;jsessionid=0e30e09a3ccb91f2c5ca5e806e7d2b2d6176?PID=22860&qualcat=BAS&qualid=SHIP_WORKER&title=BASIC SHIPBOARD WORKER" class="Normal">BASIC SHIPBOARD WORKER </a></td>
<td align="center" valign="top" class="Normal">
10/31/2011 </td></tr>
<tr><td align="left" valign="top" class="Normal">
BASSHOP_WORKER </td>
<td align="left" valign="top" class="Normal">
<a href="atms_supv_qualtree.cfm;jsessionid=0e30e09a3ccb91f2c5ca5e806e7d2b2d6176?PID=22861&qualcat=BAS&qualid=SHOP_WORKER&title=BASIC SHOP WORKER" class="Normal">BASIC SHOP WORKER </a></td>
<td align="center" valign="top" class="Normal">
10/31/2011 </td></tr>
Any help/guidance is appreciated.
TheChazm
Re: Inputing into db from Website
Never mind I figured it out. Took around 8 hrs but got it!
Code:
MsgBox WebBrowser1.Document.Getelementbyid("tblcourses").rows(1).cells(1).innertext