Hi,
I don't know if this would be posible in your case, but, you could change the format of the spreadsheet before importing it.
Do you have two collumns in Access, one with first names, and one with last names, or do you have one collumns with Surname, Firstname
Let me know.