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

Its as if you wrote
my $MoneyBagFullOf$$$Dollars = 4;
You can't have the sigil $ as part of a variable name, its a syntax error

You need to use placeholders or $dbh->quote, you an read about it in DBI docs

http://w3schools.com/sql/