I have now tried these options, still with no success.

recordset.Fields(0) = '123'
recordset.Fields("Acct #") = '123'
recordset(0) = '123'

recordset.UpdateBatch

The error msg I get when using any of these options is: The INSERT INTO statement contains the following unknown field name: 'Acct #'.

If I debug this, I can see that the assignment is made correctly & I can see the field name as [Acct #]. It is when the UpdateBatch executes that I get the error message.

Thoughts?