I actually use dbd::odbc quite often to access an Access database (Although
I am usually migrating something OFF of the Access database rather than
using Access). It's not really any trick. You need to set up a DSN in your
ODBC Data Sources. That is very easy if you are on an MS platform (Just In
Case - It's in your control panel). If you are on a Linux platform, you can
get the iODBC drivers to access an Access database.
Once you get the DSN configured, and pointing to the Access database you
wish to access, all there is to it code wise is something like this:
use DBI;
my $dsn = "dsn_name";
my $database = "DBI:ODBC:$dsn";
my $db_user = "";
my $db_password = "";
# connect to the Access db.
my $dbh = DBI->connect($database,$db_user,$db_password);
You should be there.
Steve Howard
-----Original Message-----
From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 2:06 PM
To: Alex; [EMAIL PROTECTED]
Subject: Re: MS Access
Microsoft provides ODBC drivers for Access. That should mean you can use
DBD::ODBC with DBI to work with Access. Exactly how useful this is for you
depends on you platform.
Without knowing what you have already tried, and what problems you had, it
will be difficult for anyone on the list to make any suggestions.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Alex" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 19, 2001 11:31 AM
Subject: MS Access
> Sorry to bother you but I feel pretty dumb by searching the net and
> reading page after page without understanding anything. I use perl and
> mysql alot and I would like to access a microsoft Acess MDB file just
> like I access a mysql database.
>
> What would I have to do? I just don't get it. Every driver I installed
> just gives me new hints an trying other installs and so on. Is there any
> page that explains actually what to do? I can't be the first person with
> this problem.
