Question:  I have the Excel file which has the full name in one column; for example, Vannak Hou instead of in First=Vannak  Last=Hou in two different column.  So how do I import that file into Access 2010's field of First and Last name?  Instead of "manually" typing all the 100 rows to Access file.

---

Reply from Richard Rost:

There are a couple of ways you can do this. In Excel, you can select the column, go to DATA > TEXT TO COLUMNS > DELIMITED > Space Character. That will generally work for MOST of your names, assuming they all have just ONE space in there... and don't include middle names, middle initials, compound names (like Martin Van Buren). Then just import THAT into Access. I cover this in Excel Expert 1 in more detail.

There are other techniques that you can use to separate names if things are more complex. See THIS and THIS.