Thx's Peter.
Is there a way or simple means of just extracting the data from the mdb files so
we can import it into a MySQL database, something like a dump file or similar ?
Mike
----- Original Message -----
From: "Mike Blezien" <[EMAIL PROTECTED]>
To: "Perl List" <beginners@perl.org>
Sent: Wednesday, August 09, 2006 11:20 AM
Subject: Access MDF files
Hello,
is there a Perl module available to obtain data from Access .mdf files ?
thx's
Mike(mickalo)Blezien
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
DBI and DBD::ODBC
Here's a sample connection script:
==================================
#!/usr/bin/perl
use DBI;
use DBD::ODBC;
use strict;
use warnings;
my $dsn = "test.mdb";
my $dbh = DBI->connect("dbi:ODBC:driver=microsoft access driver (*.mdb);dbq="
. $dsn) or die "Can't connect to database: $dsn: $DBI::errstr\n";
if ($dbh) {
print "Connected to: $dsn\n";
$dbh->disconnect;
exit;
}
==================================
You can also use "ODBC Data Source Administrator" to setup System DSN's as
another way to connect, instead of directly to the file, like the above
example.
There's a number of tutorials on this subject that you can find by googling
"perl access tutorial" or "perl odbc access", etc...
Hope this helps,
Peter
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
