in reply to MS Access mdb files
keep in mind that Access SQL is somewhat crippled, and that many ODBC functions will not be availible because the DBI module, and the third party vendor will not support them. But you should be able to at least pull out data via select statements#!/usr/bin/perl -w use DBI ; use strict; #connect to Access file via ODBC my $accessDSN = q(driver=Microsoft Access Driver (*.mdb);). q(dbq=/home/user/mydbfile.mdb); my $dbhA = DBI->connect("dbi:ODBC:$accessDSN",'','') or die "$DBI::errstr\n";
This is a how to on this exact subject here
|
|---|