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?
Thanks in Advance.
J. Turner