my @a=keys(%prophash); my $a=join(',',@a); my @b=values(%prophash); my $b=join(',',@b); my $temp="insert into maintable ($a) values($b)"; $sth = $dbh->prepare ($temp); $sth->execute(); #### DBD::ODBC::db prepare failed: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. (SQL-42000)(DBD: st_prepare/SQLPrepare err=-1) at alldb.pl line 132, line 283.