full name import from excel

[Joso]

Hi everyone, i am creating a database by importing data from excel than normalizing it. In the excel spreadsheet thre is a full name field and want to import it into access by splitting it up into first and last name. Some of the data in the spreadsheet have middle initials. ANy idea on how to make this easier for me?

Thanks in advance

Joso

 

[Bat17]

I would do it after importing, using a query.

first: Left([FullName],InStr([FullName]," "))
Last: Mid([FullName],InStrRev([FullName]," ")+1)

HTH

Peter