>I am trying to import an excel spreadsheet to access table. In the spreadsheet, the names are in the format (LASTNAME, FIRSTNAME). How can I programmatically sparse the cells and place the LAST NAME and FIRST NAME in the respective fields in the table?
You might like the split function like in a = split("aaaa,bbbb",",") would return "aaaa" in a[0] and "bbbb" in a[1].
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.