How to use VBA to insert record into database table when there is missing value?

1. The code works fine if there is no missing value. I have tested on one record and multiple records, the code runs fine.
2. Please note that I write FieldD and FieldF differently, because these two fields are string, the remaining five fields are integer.
3. I tested the code on a file with one single record, and if only FieldF is missing, the code runs fine and is able to insert the other 6 fields into database table.
4. I tested the code on a file with one single record, and if only FieldE is missing, the code does not run, see the attached error message.

Column A will never be missing, so it is fine for the code to check LastRow.

I need to add some space in SQL code, in order to post the code.

Please Login or Register  to view this content.

Another question: how to test if a record is already in the database table? The database system will generate error message if the identical record is already in the database table, how should I use VBA to check it then I can skip adding that record.

Thanks.