The following ASPDB PRO line yields a syntax error:
MyDb.dbSilentCmdText = "(;|)INSERT INTO History (ItemNum) VALUES (" & Session("ASPdb_1991_ItemNum" & ""
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.