I am using access to insert records into quickbooks using qodbc. I have a VBA DoCmd.RunSQL to insert an InvoiceLine using a statement I build dynamically. I have a MsgBox that reports the statement right before calling DoCmd.RunSQL and it says this:
Insert Into "InvoiceLine"...