Splitting 1 Column to Many

[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

 

[Douglas J. Steele]

Realistically, the problem won't be with SQL. Splitting the fields is
definitely going to be non-trivial.

You might want to take a look at a 3rd party product like
http://www.infoplan.com.au/splitter/