The following ASPDB PRO line yields a syntax error:

MyDb.dbSilentCmdText = "(;|)INSERT INTO History (ItemNum) VALUES (" & Session("ASPdb_1991_ItemNum&#34 & ""

ItemNum is a numeric data field, History is the table, and ItemNum has been previously exported into a Session variable.

Anyone know what is wrong here?

Thanks.