You need to look into the Perl DBI both on the web and especially in the book Programming the Perl DBI: Database programming with perl (But if your going to buy it buy it here).

coreolyn

For me, it worked so poorly that that particular script is just using a text-file database. It didn't really need a database anyway, the boss just thought it would be slick to hook it up to one probably.

I don't understand. How did it mess up?
I've been using DBI with MS SQL Server 7 here for months now, with little in the way of headaches. Hooking up to the server, retriving/editing, etc. all work fine. The only serious problem I can think of involved Memo/OLE Object files, and that's well-documented in the DBD::ODBC docs.
----Asim, known to some as Woodrow.

#!/usr/local/bin/perl -w
use strict;
=head
    Win32::OLE using a System DSN called testconn
    Objectives: Read stuff from an MSAccess database to prove that thi
+s works
                Error handling tests                
=cut

use OLE;
my $Conn = CreateObject OLE "ADODB.Connection";
$Conn->Open("DSN=testconn");
my $RS = $Conn->Execute("Select * from Customers");

if (!$RS)
{
my $Errors = $Conn->Errors();
my $error;
 foreach $error (keys %$Errors)
{
        print $error->{Description}, "\n";
}
}
while(!$RS->EOF)
{
print $RS->Fields('CustomerID')->value, "\n", $RS->Fields(2)->value,"\
+n";
$RS->movenext();
}
1;
[download]

I suppose you can look around for more information on Win32::OLE on the web. The perldoc includes more examples on how to access Microsoft Excel.

Celebrate Intellectual Diversity