my $db = "1,1,1-Trichloroethane_Chem2981.mdb"; my $table ="1,1,1-Trichloroethane_Chem2981"; $dbh = DBI->connect( "dbi:ODBC:driver=Microsoft Access Driver (*.mdb, *.accdb); dbq=$db","",""); $sql = "SELECT * FROM $table"; $sth = $dbh->prepare( $sql ) or die;