Split Name

[juneau730]

Hello all,

I have a macro in Excel that splits a column that contains a full name (Smith,Bob H) into three new columns (LN, FN, MN) and it works great there. I am trying to get something similar that will perform the same function from Access, prior to importing the data into a database table, but I need to to either be embedded into the "import" sub code or as a call to a secondary sub.

I did search for this and saw a lot for excel, but that's not what I need

 

[dellehurley]

Thank you dellehurley.

May be a silly question, but how does this code know where to read the full name from and where to put the LN, FN and MI?

If you want me to rework this for you (in Access this time) that is fine could you give me your table details. Names and Field Names and Primary Key details.
D