Newbie:Accessing MS-Access from Perl [Archive]

View Full Version : Newbie:Accessing MS-Access from Perl

cusp

02-16-03, 19:40

Hi all,

I wanted to know if it is possible to connect to MS-Access database from a Perl script, on a Windows-2000 box.Searched the net for some tutorials, but could not find any.Could anyone help me out??

-Cusp

Bernd Dulfer

02-17-03, 04:48

Have a look at DBI and DBD::ODBC:

http://search.cpan.org/author/TIMB/DBI-1.32

http://search.cpan.org/author/JURL/DBD-ODBC-1.04

You can get both for win32 at activestate (www.activestate.com).

GadgetGuru

02-21-03, 08:34

like suggested above;

...
use Win32::ODBC;
$dsn = "<yourDSNtoACCESS>";
$db = new Win32::ODBC($dsn);
...
$sql3 ="select * from blabla WHERE blabla..";
$db->Sql($sql);

...