PDA

Click to See Complete Forum and Search --> : Importing data from a table on a webpage into an access db

Rbenfield
Jan 26th, 2000, 01:35 AM
I am trying to find an easy way to import data from tables on a webpage into an access database. I can have it setup so that the user must save the page to the hard drive as a txt file and import from that text file if need be or straight from the internet would be great. Here is a sample of a page. all i really need from it is column 2 for all rows from all tables and only lines 1, 3 and 4. Any help you can give would be greatly appreciated.

<HTML>
<HEAD>
<TITLE>Import data from tables on page like this</TITLE>
</HEAD>
<BODY BGCOLOR="#CCCCCC" TEXT="#00007F"><CENTER></CENTER>
<H2 ALIGN=center>Tables 1, 2 and 3 to import data from</H2>
<CENTER>
<TABLE BORDER=1 CELLPADDING=2 WIDTH="100%">
<TR>
<TH WIDTH="9%">Column<br>1<br>Label</TH>
<TH WIDTH="22%">Column<br>2<br>Label</TH>
<TH WIDTH="20%">Column<br>3<br>Label</TH>
<TH WIDTH="10%">Column<br>4<br>Label</TH>
<TH WIDTH="10%">Column<br>5<br>Label</TH>
<TH WIDTH="7%">Column<br>6<br>Label</TH>
</TR>
<TR> <TD VALIGN=top WIDTH="9%"><FONT SIZE=-1><A HREF="../test/cgi-bin/query.pl?record_no=001&puid=001122334455">C_1_R_1_Info</A></FONT>
<TD VALIGN=top WIDTH="22%" ALIGN=left><FONT SIZE=-1><B>C_2_R_1_L_1</B><br>C_2_R_1_L_2<br>C_2_R_1_L_3<br>C_2_R_1_L_4</FONT></TD>
<TD VALIGN=top WIDTH="20%" ALIGN=left><FONT SIZE=-1><B></B>Column_3<br>Row_1_Info</FONT></TD>
<TD VALIGN=top WIDTH="10%" ALIGN=left><FONT SIZE=-1><CENTER>01/01/95</CENTER> </FONT></TD>
<TD VALIGN=top WIDTH="10%" ALIGN=left><FONT SIZE=-1><CENTER>01/01/00</CENTER> </FONT></TD>
<TD VALIGN=top WIDTH="7%" ALIGN=left><FONT SIZE=-1><CENTER>00</CENTER> </FONT></TD>
</TR>
<TR> <TD VALIGN=top WIDTH="9%"><FONT SIZE=-1><A HREF="../test/cgi-bin/query.pl?record_no=002&puid=001122334455">C_1_R_2_Info</A></FONT>
<TD VALIGN=top WIDTH="22%" ALIGN=left><FONT SIZE=-1><B>C_2_R_2_L_1</B><br>C_2_R_2_L_2<br>C_2_R_2_L_3<br>C_2_R_2_L_4</FONT></TD>
<TD VALIGN=top WIDTH="20%" ALIGN=left><FONT SIZE=-1><B>C_3_R_2_L_1</B><br>C_3_R_2_L_2<br>C_3_R_2_L_3<br>C_3_R_2_L_4</FONT></TD>
<TD VALIGN=top WIDTH="10%" ALIGN=left><FONT SIZE=-1><CENTER>01/01/95</CENTER> </FONT></TD>
<TD VALIGN=top WIDTH="10%" ALIGN=left><FONT SIZE=-1><CENTER>01/01/00</CENTER> </FONT></TD>
<TD VALIGN=top WIDTH="7%" ALIGN=left><FONT SIZE=-1><CENTER>00</CENTER> </FONT></TD>
</TR>
</TABLE>
</TABLE>
<br><TABLE BORDER=2 WIDTH=100% CELLPADDING=2>
<TR> <TD VALIGN=top WIDTH="9%"><FONT SIZE=-1><A HREF="../test/cgi-bin/query.pl?record_no=003&puid=001122334455">C_1_R_1_Info</A></FONT>
<TD VALIGN=top WIDTH="22%" ALIGN=left><FONT SIZE=-1><B>C_2_R_1_L_1</B><br>C_2_R_1_L_2<br>C_2_R_1_L_3<br>C_2_R_1_L_4</FONT></TD>
<TD VALIGN=top WIDTH="20%" ALIGN=left><FONT SIZE=-1><B>C_3_R_1_L_1</B><br>C_3_R_1_L_2<br>C_3_R_1_L_3<br>C_3_R_1_L_4</FONT></TD>
<TD VALIGN=top WIDTH="10%" ALIGN=left><FONT SIZE=-1><CENTER>01/01/95</CENTER> </FONT></TD>
<TD VALIGN=top WIDTH="10%" ALIGN=left><FONT SIZE=-1><CENTER>01/01/00</CENTER> </FONT></TD>
<TD VALIGN=top WIDTH="7%" ALIGN=left><FONT SIZE=-1><CENTER>00</CENTER> </FONT></TD>
</TR>
<TR> <TD VALIGN=top WIDTH="9%"><FONT SIZE=-1><A HREF="../test/cgi-bin/query.pl?record_no=004&puid=001122334455">C_1_R_2_Info</A></FONT>
<TD VALIGN=top WIDTH="22%" ALIGN=left><FONT SIZE=-1><B>C_2_R_2_L_1</B><br>C_2_R_2_L_2<br>C_2_R_2_L_3<br>C_2_R_2_L_4</FONT></TD>
<TD VALIGN=top WIDTH="20%" ALIGN=left><FONT SIZE=-1><B></B>Column_3<br>Row_2_Info</FONT></TD>
<TD VALIGN=top WIDTH="10%" ALIGN=left><FONT SIZE=-1><CENTER>01/01/95</CENTER> </FONT></TD>
<TD VALIGN=top WIDTH="10%" ALIGN=left><FONT SIZE=-1><CENTER>01/01/00</CENTER> </FONT></TD>
<TD VALIGN=top WIDTH="7%" ALIGN=left><FONT SIZE=-1><CENTER>00</CENTER> </FONT></TD>
</TR>
</TABLE>
</TABLE>
<br><TABLE BORDER=2 WIDTH=100% CELLPADDING=2>
<TR> <TD VALIGN=top WIDTH="9%"><FONT SIZE=-1><A HREF="../test/cgi-bin/query.pl?record_no=005&puid=001122334455">C_1_R_1_Info</A></FONT>
<TD VALIGN=top WIDTH="22%" ALIGN=left><FONT SIZE=-1><B>C_2_R_1_L_1</B><br>C_2_R_1_L_2<br>C_2_R_1_L_3<br>C_2_R_1_L_4</FONT></TD>
<TD VALIGN=top WIDTH="20%" ALIGN=left><FONT SIZE=-1><B>C_3_R_1_L_1</B><br>C_3_R_1_L_2<br>C_3_R_1_L_3<br>C_3_R_1_L_4</FONT></TD>
<TD VALIGN=top WIDTH="10%" ALIGN=left><FONT SIZE=-1><CENTER>01/01/95</CENTER> </FONT></TD>
<TD VALIGN=top WIDTH="10%" ALIGN=left><FONT SIZE=-1><CENTER>01/01/00</CENTER> </FONT></TD>
<TD VALIGN=top WIDTH="7%" ALIGN=left><FONT SIZE=-1><CENTER>00</CENTER> </FONT></TD>
</TR>
<TR> <TD VALIGN=top WIDTH="9%"><FONT SIZE=-1><A HREF="../test/cgi-bin/query.pl?record_no=006&puid=001122334455">C_1_R_2_Info</A></FONT>
<TD VALIGN=top WIDTH="22%" ALIGN=left><FONT SIZE=-1><B>C_2_R_2_L_1</B><br>C_2_R_2_L_2<br>C_2_R_2_L_3<br>C_2_R_2_L_4</FONT></TD>
<TD VALIGN=top WIDTH="20%" ALIGN=left><FONT SIZE=-1><B>C_3_R_2_L_1</B><br>C_3_R_2_L_2<br>C_3_R_2_L_3<br>C_3_R_2_L_4</FONT></TD>
<TD VALIGN=top WIDTH="10%" ALIGN=left><FONT SIZE=-1><CENTER>01/01/95</CENTER> </FONT></TD>
<TD VALIGN=top WIDTH="10%" ALIGN=left><FONT SIZE=-1><CENTER>01/01/00</CENTER> </FONT></TD>
<TD VALIGN=top WIDTH="7%" ALIGN=left><FONT SIZE=-1><CENTER>00</CENTER> </FONT></TD>
</TR>
</TABLE>
</CENTER>
<P>
<P>
</BODY>
</HTML>

Thanks In Advance,
Richard