Quickest way would be to use the Split() function to break the field down into separate sections and then use DAO or ADO to put the split components into the relevant fields.
Will the name always come in three parts or will you get data like:
Mr W Wobbly
Mrs Bloggs
Fred Bunberry
Hubert D. Booby
etc?
