How to delete records from MS Access DB.

[petri . o . salonen]

Hi,

How I can delete records from MS Access DB using DBI module.
I want to delete a records which are "too" old.


This would be easy if I could use Oracle DB then would work like this.


  _____  


my $accessth = $Access_dbh->prepare( q{delete from Data
where (DATE_TIME < to_date('2001-06-01 12:30:00', 'YYYY-MM-DD HH24:MI:SS')
}) || die "Can't prepare statement: $DBI::errstr"; 

my $rv = $accessth->execute() || die "Can't execute statement:
$DBI::errstr";


  _____  

But how to do it with Access DB?