Here's how I used to connect using DBI and DBD::ODBC. I would pass the
access database's name as a parameter. From here you can just use dbi and
SQL to manipulate the DB. If you need more help with DBI I would recommend
posting in the dbi-users group.
my $dbh = DBI->connect("dbi:ODBC:driver=Microsoft Access Driver
(*.mdb);dbq=$ARGV[0]", '','') || die "$DBI::errstr\n";
-----Original Message-----
From: Josh Berkus [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 5:45 PM
To: Dan Muey; [EMAIL PROTECTED]
Subject: Re: Access DB
Dan,
> Has anyone worked with Microsoft Access Databases with perl?
>
> I either need to run a query on a remote Access Database or
> Have the people that have that database save it in CSV format
> or something to import it into mysql.
>
> Any ideas how best to deal with Access Databases with perl?
Look up "MDB Tools" on Freshmeat.net
--
-Josh Berkus
Aglio Database Solutions
San Francisco
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
