DB Convert Employee Name in fields
Posted on 2012-08-30
I have an Access 2007 DB and one of the main tables "TABLE-A" has a "Name Employee" field name and Text data type. Almost 98% are "LASTNAME, FIRSTNAME MIDDLENAME". The other 2% are either "LASTNAME, FIRSTNAME MI", "LASTNAME, FIRSTNAME".
I have another table "TABLE-B" that has a "Name Employee" field name and Text data type. Almost 98% are "Lastname, Firstname MI". The other 2% are "Lastname, Firstname".
TABLE-B is a new import table and everything that we go off of is in TABLE-A using "Name Employee". I wil be importing TABLE-B once a week.
How can I convert TABLE-B Name Employee to match TABLE-A Name Employee?
I am open to any and all ideas on how to best do this, I am very new to DB's.