How do I parse this?

[Benny Wong]

Hello All,
I am currently using Microsoft Access 2000. I have a table named tblclient. In the table I have fields named:

FirstName
MiddleInitial
LastName
ETC....

I have a number of data sources that I would like to import into tblclient. The data sources are a combination of Excel file and Access database format. The problem that I have is the data sources has the FirstName, MiddleInital, and LastName in only one field as Name. How do I parse this into the respective fields as FirstName, MiddleInitial, and LastName? There is also another twist in this some do not have MiddleInitial. What is the procedure do I need to accomplish this task...query, vba, sql, macro?
Thanks for you assistance in advance.

 

[Jack Cowley]

You will find your answer here.

hth,
Jack

 

[Benny Wong]

Hello Jack,

Thanks for your response and the tip!

 

[Jack Cowley]

You are welcome. Good luck with your project....

Jack