Please help me to copy Data from html table to an access database!

ijared has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Please help me to copy Data from html table to an access database! by marto (Cardinal) on Jul 05, 2007 at 18:14 UTC
Hi ijared, In addition to reading the PerlMonks FAQ and How do I post a question effectively? I think you should familiarize yourself with HTML::TokeParser::Simple which you could use to strip the data from the table and DBI to connect to the Access database. If you need help installing modules check out Installing Modules from the tutorials section of this site. Hope this helps Martin	[reply]
Re: Please help me to copy Data from html table to an access database! by jZed (Prior) on Jul 05, 2007 at 21:27 UTC
The module DBD::AnyData can serve as a front-end to HTML::TableExtract. You can then use DBI to insert the data into Access. Something like this: `#!/usr/bin/perl use warnings; use strict; use DBI; my $access_dbh= DBI->connect(...); my $ad_dbh= DBI->connect('dbi:AnyData(RaiseError=1):'); $ad_dbh->ad_catalog('Temp','HTMLtable', $url, { $html_table_extract_fl +ags}); my $select = $ad_dbh->prepare("SELECT * FROM Temp"); my $insert = $access_dbh->prepare("INSERT INTO foo VALUES(...)"); $select->execute; while( my $row = $select->fetchrow_arrayref ) { $insert->execute(@$row); }` [download] This presumes you have already created a table with the appropriate structure in Access.	[reply] [d/l]