#Using ADO from PERL
use Win32::OLE;

my $Conn=Win32::OLE->new('ADODB.Connection') or die "Unable to create ADODB.Connection";

#NB.You will need to set up the DSN in the ODBC Data Manager (Control Panel)
#	MUST be done on the System DSN tab, you may to enter user name and password
#Don't or die on these methods - it dies every time!

$Conn->Open("<db name in Data Manager>","<optional userid>","<optional password>");
$RS=$Conn->Execute("SELECT * FROM <table>");

$RS->MoveFirst();

until ($RS->Eof()) {
	print $RS->Fields->{'Name'}->Value,"\n";
	$RS->MoveNext();
}

$RS->Close;
$Conn->Close;