How do I parse this? (1 Viewer)

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.

You will find your answer here.

hth,
Jack

Hello Jack,

Thanks for your response and the tip!

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

Jack