Two tables:
KeyTable, has one column called LKey,
ParsedTable has one column called RightKey
Neither table is empty.
I want to add to Keytable those records in ParsedTable that are NOT in KeyTable.
I(Try) use
INSERT INTO KeyTable SELECT ParsedTable.RightKey FROM ParsedTable
LEFT JOIN KeyTable ON
ParsedTable.RightKey = KeyTable.LKey WHERE KeyTable.LKey IS NULL.
ACCESS DoCmd.RunSql insists it can't find RightKey
An ACCESS FORM has no trouble.
The sample given to me in an earlier answer works, but I just can't seem to translate it to my needs.
I'm about to punt, and use something that makes sense, like VBA, opening two recordsets, and comparing them.