Update Access Database MDB -- 2

I have a microsoft access database and require a script or preferably an exe file to delete all data from a column within a specified table and then replace it with amended data from a different column within the same row of the same table.

For example, the column used to store an email address needs to have all values deleted, and replaced with the data contained within the mobile number column; but also have the mobile number trimmed and all spaces removed PLUS have (at) domain d0t com d0t au appended at the end.

Microsoft Access

Ταυτότητα Εργασίας: #6780941

Σχετικά με την εργασία