[AccessD] Separating First and Last Names

I have received a large file containing a large number of Full Names.
I need to separate the First Name and Middle Initial, if any, into one field
and the Last Name into a separate field.
 
What is the most efficient way to do this?
 
Thanks!
 
Welford Coutts
 
 




-----------------------------------------
CONFIDENTIALITY NOTE:  This e-mail message, including any
attachment(s), contains information that may be confidential,
protected by the attorney-client or other legal privileges, and/or
proprietary non-public information.  If you are not an intended
recipient of this message or an authorized assistant to an intended
recipient, please notify the sender by replying to this message and
then delete it from your system.  Use, dissemination, distribution,
or reproduction of this message and/or any of its attachments (if
any) by unintended recipients is not authorized and may be unlawful.