Splitting 1 Column to Many

  • Thread starter Thread starter Robert Wild
  • Start date Start date
R

Robert Wild

Hi all,

A quick question with what is probably going to be a difficult answer.

I have about 120K records that just have a 'Name' field. I need to be
able to split this 'name' field into a 'FirstName', 'MidName' and
'Surname' field.

The names themselves are all seperated by just a space, however the
names vary from just "Fred Smith" to "Frederick Samuel Montgomery Van
Der Smith"

How can I do this via an update query? I'm afraid that I do not know SQL
or VBA.

any assistance would be apperciated.

cheers

Rob
 
Back
Top