I have an existing ms access table.
I want to use VBA to append a new field (column) with the DataType as Short Text and assign a value of "Imported" into that field. It should not be a mandatory or required field.
Kindly assist with the appropriate VBA Code.