in reply to Crummy Characters in Access Table name (DBI)

You need to quote the table name - use quote_identifier

  • Comment on Re: Crummy Characters in Access Table name (DBI)

Replies are listed 'Best First'.
Re^2: Crummy Characters in Access Table name (DBI)
by Blue_eyed_son (Sexton) on Jul 08, 2011 at 15:27 UTC
    Thanks, mje. This did the trick: 
    $qtable=$dbh->quote_identifier($table);
$sql = "SELECT * FROM $qtable";
$sth = $dbh->prepare( $sql ) or die;
$sth->execute();

    [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom