saqa.PNG

<div>
I will try that thanks. Many thanks.
</div>


<div>
Thanks Gustav,<br />
I got it in Excel and I know how to read from Excel.<br />
Fritz
</div>


Thanks Gustav,
I got it in Excel and I know how to read from Excel.
Fritz

<div>
OK, great.<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
I have a Microsoft Access 2010 Database with a table and a form to read data from a webpage. <br />
When I enter a number into the form, the form must have code to open the corresponding webpage and read a range of data from fields in the web page into the table in the database. <br />
I only want the pages as I enter the numbers (SAQA QUAL ID = fugures long). I don't want the whole website as the information may change any time.<br />
Typical page addresses are <br />
<a href="http://allqs.saqa.org.za/showQualification.php?id=62322" rel="ugc">http://allqs.saqa.org.za/showQualification.php?id=62322</a><br />
<a href="http://allqs.saqa.org.za/showQualification.php?id=59769" rel="ugc">http://allqs.saqa.org.za/showQualification.php?id=59769</a>&nbsp;<br />
Note the 5 digit number at the end. So I think that will be simple to just add the number to the first part of the url. But what then?<br />
I want the attach the VBA code to the provided button on the form. <br />
Database is attached<br />
Where and how should I start?
</div>
</div>


I have a Microsoft Access 2010 Database with a table and a form to read data from a webpage. 
When I enter a number into the form, the form must have code to open the corresponding webpage and read a range of data from fields in the web page into the table in the database. 
I only want the pages as I enter the numbers (SAQA QUAL ID = fugures long). I don't want the whole website as the information may change any time.
Typical page addresses are 
http://allqs.saqa.org.za/showQualification.php?id=62322
http://allqs.saqa.org.za/showQualification.php?id=59769 
Note the 5 digit number at the end. So I think that will be simple to just add the number to the first part of the url. But what then?
I want the attach the VBA code to the provided button on the form. 
Database is attached
Where and how should I start?

How to extract data from a webpage and enter into an Access Database?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.