http://qs321.pair.com?node_id=189079

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

hi, I need to insert data into an MS ACCESS database
usingWIN32::OLE (not DBI or WIN32::ODBC, but WIN32::OLE). The following method works for me to read the data from thedatabase: use Win32::OLE; my $db = new Win32::OLE('ADODB.Connection'); $db->open("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=data.mdb"); $RS = $db->Execute("SELECT * FROM members"); $usa=$RS->Fields('name')->value; $ema=$RS->Fields('email')->value; print "$usa|$ema<br>"; $RS->MoveNext; $RS->close; $db->close; now i need something similar, but will insert
thevalues "a1" into name and "a2" into email(being examples)
into members table of the database. plz
help...